Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 Poll Discussion
 uppercase

Author  Topic 

gopinathsm89
Starting Member

1 Post

Posted - 2011-12-26 : 23:42:33
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

52326 Posts

Posted - 2011-12-27 : 03:27:21
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

2937 Posts

Posted - 2011-12-27 : 03:32:53
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
   

- Advertisement -