how to select a field with firstletter as capital and remaining are small lette

how to select a field with firstletter as capital and
remaining are small letters

Question Posted / prasad

Answers were Sorted based on User's Feedback

how to select a field with firstletter as capital and remaining are small letters..

Answer / guest

UCASE

Is This Answer Correct ?

0 Yes

3 No

More SQL Server Interview Questions

How to create an index on an existing table in ms sql server?

Why we need a group by clause?

What are the different types of backup avaible in SQL SErver

Do you know what is sql injection?

What are mdf,ndf,ldf files and how to see the data in those files?

How to transfer Logins from SQL Server 2000 to 2005

Explain few examples of stored procedure over triggers?

What is coalesce and check constraint in sql server?

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

What is transaction server auto commit?

What is amo? : sql server analysis services, ssas

What is the order in which the SQL query is executed? list them in order.

For more SQL Server Interview Questions Click Here