Hi Peter

At 07:34 pm 14/09/2004, you wrote:

>If you want to use substring the syntax is
>SELECT SUBSTRING( MyCharField FROM 1 FOR 5) FROM MyTable
>You only need to CAST if the selected field is not of character type.

I tried to cast the Blob Text to varchar and then substring it but the cast
to varchar did not work.

SUBSTRING(CAST(mAddress) as VARCHAR(100)) FROM 1 FOR 44)




Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://ahmedabad.sancharnet.in/vso_ad1/
namitbn@...
___________________________________________

----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.762 / Virus Database: 510 - Release Date: 13/09/2004


[Non-text portions of this message have been removed]