SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 Poll Discussion
 uppercase		  New Topic  Reply to Topic
 Printer Friendly
Author  Topic Next Topic  

gopinathsm89
Starting Member

India
1 Posts
Posted - 12/26/2011 :  23:42:33  Show Profile  Reply with Quote
i post lower case for username,
i am using these query SELECT * FROM register WHERE username = '" . $username . "'
how i get uppercase value using db.

gopinath

visakh16
Very Important crosS Applying yaK Herder

India
47157 Posts
Posted - 12/27/2011 :  03:27:21  Show Profile  Reply with Quote
use UPPER() function

http://msdn.microsoft.com/en-us/library/ms180055.aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page

Sachin.Nand
Flowing Fount of Yak Knowledge

2937 Posts
Posted - 12/27/2011 :  03:32:53  Show Profile  Reply with Quote
quote:
Originally posted by gopinathsm89

i post lower case for username,
i am using these query SELECT * FROM register WHERE username = '" . $username . "'
how i get uppercase value using db.

gopinath


Is that php ?

PBUH
Go to Top of Page
   Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000