Hi all

I have this FB table containing a BLOB (Text) field. For a remote views
select statement I have written this in VFP6 as below:

SELECT MCUSTOMSOFFICE.*, LEFT(MCUSTOMSOFFICE.mAddress, 44) AS cShortAddress ;
FROM MCUSTOMSOFFICE MCUSTOMSOFFICE ;
ORDER BY MCUSTOMSOFFICE.CNAME

The LEFT() does not seem to be recognized by FB/ODBC, what is the
equivalent of LEFT()

Please advise.




Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
namitbn@...
___________________________________________

----------


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


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