Proper Case in the Query
We can use upper/lower , but what is the syntax for proper case?
eg: LCASE(a.str_inspector)
[181 byte] By [rkbnair] at [2007-11-11 10:11:32] 
In the query, I want to display a field in proper case. Is it possible?
We can use upper/lower , but what is the syntax for proper case?
eg: LCASE(a.str_inspector)
# 1 Re: Proper Case in the Query
Look at the StrConv() function. It is normally used to convert back and fourth between normal strings and Unicode strings; but it also has the ability to create proper case strings.StrConv(a.str_inspector, vbProperCase)
Ron Weller at 2007-11-11 23:43:25 >
# 2 Re: Proper Case in the Query
Sir,I want to use it in the backend; I mean in SQL Server 2000 query itself.
thanks
rkbnair at 2007-11-11 23:44:30 >
# 3 Re: Proper Case in the Query
SQL Server does not have any built-in way to convert a string to proper case, but I'll bet you can find a solution on the Web by searching for, say, "t-sql proper case." ;-)Phil Weber at 2007-11-11 23:45:29 >
