Equivalent strconv in Advantage SQL DB

[bk171]

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

[justsomeguy]

It looks like this is the list of string functions you have available:

https://devzone.advantagedatabase.com/dz/webhelp/Advantage7.1/supported_statements/string_functions.htm

If it's not in that list, then you can't do it in SQL.  If you are required to use that particular database for some reason then you need to do it in another language.