Newbie Question

[dand11]

I have a query that is returning some data with some code concatenated in front as such:

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?

 

[mirtheil]

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

http://www.mirtheil.com