Jump to content

Equivalent strconv in Advantage SQL DB


Recommended Posts

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.


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

Link to comment
Share on other sites

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


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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...