>>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
>
>I have not tried this but maybe----
>
>substr(field1,AT('#',field1)+ 1,len(alltrim(field1))
>
>HTH
>Jeff
Hi Jeff,
Thanks for the suggestion, I had my fingers crossed when I tried, but still returning only one character for result, which BTW is the correct first character, I'm just not getting the rest of the string. I know I've done this before...just can't figure out how i did it.
Thanks.
John.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only