Jump to content
Sign in to follow this  
bk171

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.

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
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
Sign in to follow this  

×