string functions in SQL to capitalize first letter similar to Prop

[PN_Samm]

Is there a string function that is similar to the Proper() function in SQL
When I try strconv(field),3 I get error msg.

Thanks

 

[Rick Brandt]

Is there a string function that is similar to the Proper() function
in SQL When I try strconv(field),3 I get error msg.

Thanks

The 3 needs to be inside the parenthesis. Or was that just a typo in your post?
If so, what is the error message?

 

[Dave Patrick]

Should have been
STRCONV(field,3)

See if this article helps.
http://support.microsoft.com/default.aspx?scid=kb;EN-US;815282


--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
| Is there a string function that is similar to the Proper() function in SQL
| When I try strconv(field),3 I get error msg.
|
| Thanks