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
- 19375 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 can a database be repaired?
Do you know what is sql service broker?
Why do we use non clustered index?
What is service broker? : sql server database administration
Explain the concept of recursive stored procedure.
User wants only to display only pdf as export option in report manager. How to achieve this?
Explain Geometry datatype in sql server 2008 with example
How to find the version of sql server? : sql server database administration
Can primary key be a foreign key?
How to change parameter value inside the report?
What are system databases in ms sql server?
Will sql server 2005 allow you to reduce the size of a column?
What is instead of trigger sql server?
What do you mean by an execution plan? Why is it used? How would you view it?
what is blocking? : Sql server database administration
