Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

I'm using... insert into Use

Status
Not open for further replies.

gtbikerider

Technical User
May 22, 2001
81
GB
I'm using...

insert into Users FirstName
values ('john')

...to add a value to a db. How would I force an initial capital letter? eg "john" becomes "John". I think its InitCap in sql but I can't figure out the precise syntax.

--
John Carratt
 
See my FAQ:

Convert String to ProperCase, UPPERCASE, lowercase
faq181-790

Joe Miller
joe.miller@flotech.net
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top