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
- 19052 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 the purpose of the tempdb database?
What is filestream?
Where the sql logs gets stored?
What is microsoft sql server?
What is the syntax to execute the sys.dm_db_missing_index_details?
what is difference between view and Dip.
How to execute the cursor queries with "open" statements?
What is sql profiler. What are the default templates with it? : sql server database administration
How is sql used in sql server?
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration
Explain cdc and sql injection?
What is the need for group functions in sql?
Do you know the capabilities of cursors?
What happens if date-only values are provided as date and time literals?
What is difference between delete & truncate commands?
