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
- 18567 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
How do I create a stored procedure in dbml?
How to create a trigger for insert only?
What is a trigger and types of a trigger?
where can you add custom error messages to sql server? : Sql server administration
What do you understand by mirroring and mention the advantages of the mirroring?
What is the difference between varchar and nvarchar datatypes?
How to create a user name in a database?
What are the differences between local and global temporary tables?
Do you know the cursor types?
How to list all triggers in the database with sys.triggers in ms sql server?
How to select true false based on column value in sql server?
Explain the difference between clustered and non-clustered index?
Where are stored procedures in sql server?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
What is the difference between for trigger and after trigger?
