Hi

Thanks for responding.

At 08:19 pm 13/09/2004, you wrote:

>for varchar fields you can use
>SUBSTRING(value FROM startpos [FOR length])

With your help I have tried this for a character field and it works

>SUBSTRING(CAST(value) as VARCHAR(100)) FROM startpos [FOR length])

Here I assume value means the field name? So I created something like

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

this didn't work. Any other suggestions.




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.760 / Virus Database: 509 - Release Date: 10/09/2004


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