Hi, I need to convert data in a table, firstname, middlename, lastname address etc to mixed case. eg:If the first name = SAM ADAMS then it should be Sam Adams. If the Address is APT# 2345 then it should be Apt# 2345.
I can't seem to find the sql function. How should I do it ?
Thanks in advance.
I can't seem to find the sql function. How should I do it ?
Thanks in advance.