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
- 18668 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 are the drawbacks of reporting in ssrs?
What is the purpose of indexing?
Can you explain what are various ways to enhance the ssrs report?
What are the different types of stored procedures?
Can you explain important index characteristics?
What do you understand by physical_only option in dbcc checkdb?
Can we return Data from 4(more than 1) tables in stored procedure?
What is raid and what are different types of raid levels?
What are the different types of replication are there in sql server 2000?
How do I save a stored procedure in sql server?
What is sql server profiler?
Explain the truncate command?
what is normalization? Explain different levels of normalization? : Sql server database administration
What are the differences between union, intersect, and minus operators?
Why union all is faster than union?
