Interested to Buy Any Domain ? << Click Here >> for more details...
how to select a field with firstletter as capital and
remaining are small letters
- 11 Answers
- 18938 Views
- I also Faced
- E-Mail Answers
Answer Posted / bobby
select ascii('a')as a,ascii('z')as z
select ascii('A')as A,ascii('Z')as Z
select * from Table_name where (ascii(<COLUMNNAME>))
between 65 and 90)and
ascii(substring(<COLUMNNAME>,2,1)) between 97 and 122
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is plan freezing?
Can a function call a stored procedure in sql server?
What is the difference between deallocate cursor and close cursor?
What are the instances when triggers are appropriate?
How to rename an existing column with sql server management studio?
What is the difference between clustered index and primary key?
What do you understand by intent locks?
What are the benefits of filtered indexes?
What does the on delete cascade option do?
In which tcp/ip port does sql server run? Can it be changed?
What is an etl file?
What is normalization? Describe its different types.
How can I add Reporting Services reports to my application?
What is cursor in ms sql server?
Explain the xml support sql server extends?
