write a query allow only 4 characters in name column using sql server?

Posted by aswinialuri-19361 on 7/29/2013 | Category: .NET Framework Interview questions | Views: 2912 | Points: 40

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

select name from salary where name like '____'
after like 4 dashes with in single quote
Output:ashu
siri
hari

the output will shown like that it can show only 4 characters

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : write a query name starts with 's' using s ...

Next > : How to allow only alphabets using regular expressi ...

Comments or Responses

Posted by: Yesda on: 8/20/2013 | Points: 10

Good sharing...............

More Interview Questions by aswinialuri-19361

How to allow only alphabets using regular expression validator?
How many generations in Gc within managed heap and what are the defaul ...
what is the max size of rows in a particular table
how to detect the product level,product version and edition in sql ser ...
In.Net which is the parent class to create all windows service?
how to change the database owner?
What is the maximum size of columns in a particular table?
How to convert server name to host name?

Latest Interview Questions

How does the lifecycle of Windows services differ from Standard EXE?
In WCF, which binding is used for cross-machine communication or WCF-t ...
Which one is the right way to get the TextBox value with id="txtb ...
What is inheritance hierarchy?
How to call an action Method on the click of a link?
What is the difference between inline code and code behind in asp.net?
Which of the following statement is correct regarding .exe and .dll
Considering @Page Directives which of the following options suits this ...
More ...