bk171 Posted January 31, 2019 Share Posted January 31, 2019 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 Link to comment Share on other sites More sharing options...
justsomeguy Posted January 31, 2019 Share Posted January 31, 2019 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. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now