>>Shouldn't the select below return "5300" for the value?
>>
>>field1 = "CAMINO LOS REALES LOT#5300"
>>
>>select substr(field1,AT('#',field1)+ 1) from TABLE1 into cursor query
>>
>>All I am getting as a returned result is the first character of 5. I tried doing query below to force substr to return 10 characters after the number that the AT() function returns, but again all I get is the first character. I've tried several variations of this simple SQL but can't get it to return every thing to the right of the "#". If I use the command window and just use -> substr(field1,AT('#',field1)+ 1)
>>the returned value is correct, but for some reason SQL doesn't work with this construct. Any help greatly appreciated.
>>
>>Thanks,
>>
>>John
>We ran a query like yours just now and it returned all of the rest of the field.
>We ran it on 2.6 fox. It worked the same from the prompt as it did
>from a SQL statement.
>We tested against a telephone number field in one of our dbfs and
>asked for the numbers after the '-'. It returned four digits for
>each record that had a phone number.

Hi Ed,

You obviously have better luck than I. I still can't get it to work correctly using this construct within a SQL statement.

John