Click here to Skip to main content
12,077,096 members (46,513 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: C# C#4.0
sql query for getting the details of the row if the first four characters matches the criteria
Posted 5-Feb-13 0:14am
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

try - hope self explanatory

select name
from tblEmployee
where substring(name,1,4)='ABCD'
  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

select * from where name like ABCD%

refer below link it might help you

http://www.1keydata.com/sql/sqllike.html
  Permalink  
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web03 | 2.8.160212.1 | Last Updated 5 Feb 2013
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100