Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Newbie Question

Status
Not open for further replies.
dand11

dand11

Programmer
Jun 24, 2008
63
US
I have a query that is returning some data with some code concatenated in front as such:


Code: 
rtf1\ansi\ansicpg1252\uc0\deff0{\fonttbl {\f0\froman\fcharset0\fprq2 Times New Roman;} {\f1\froman\fcharset2\fprq2 Symbol;}} {\colortbl;\red1\green0\blue0;\red255\green255\blue255;} {\*\generator TX_RTF32 10.1.323.501;} \deftab1134\pard\qj\li120\ri240\tx720\tx1440\tx2160\tx2880\tx3600\tx4320\tx5040\tx5760\tx6480\tx7200\tx7920\tx8640\tx9360\tx10080\plain\f0\fs24\cf1\tab  Then the data is placed here.

How can I get rid of the preceding text?
 
Sort by date Sort by votes
What is your SQL statement? If your query is just the field (with no other information), it seems that there's a lot more data in the column than you are expecting. If the data you need starts at the same place you can use the substring functions to get what you need.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

SuperComputing
  • Locked
  • Question
Derived table syntax question
Replies
12
Views
451
SuperComputing
SuperComputing
SQLDBA007
  • Locked
  • Question
IF Statement Question in Pervasive
Replies
2
Views
219
SQLDBA007
SQLDBA007
incubeware
  • Locked
  • Question
SELECT within SELECT Statement. Question
Replies
7
Views
281
mirtheil
mirtheil
Tim58
  • Locked
  • Question
Pervasive.SQL V8 Workgroup question
Replies
4
Views
208
Tim58
Tim58
derfie
  • Locked
  • Question
A few questions.
Replies
2
Views
92
derfie
derfie

Part and Inventory Search

Sponsor

Back
Top