Search code examples
sqlstringadvantage-database-server

Equivalent strconv in Advantage SQL DB

I am converting an access query that updates fields from ALL CAPS to Basically normal First Letter Capital, rest lower case. In access ive used strconv Ive havent found a similar function in advantage sql db. Ive found upper and lcase, but those dont seem to work for me.

StrConv([City],3)

An import process brings in all caps to a field called City. So City Comes in as CHICAGO, my end result would be Chicago, and this works in access using strconv,3

Solution

  • This statement should work: SELECT Upper( Left( [field], 1 ) ) + Lower( SubString( [field], 2, Length( [field] )-1 ) ) FROM CustomersTbl