Subject Re: Equivalent of VFP6 LEFT() in FB
Author Namit Nathwani

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.

Softwares for Indian Businesses at:


Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
Version: 6.0.760 / Virus Database: 509 - Release Date: 10/09/2004

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