Proper Case in the Query

[rkbnair]

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)

[Ron Weller]

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)

[rkbnair]

Sir,

I want to use it in the backend; I mean in SQL Server 2000 query itself.

thanks

[Phil Weber]

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." ;-)