Click here to Skip to main content
12,075,542 members (68,073 online)
Rate this:
 
Please Sign up or sign in to vote.
select * from table where loc=//here i have to implement logic

in table loc column have values like locations.so i need to retrieve location between 'a' and 's'.all the location having value between a and s .
Posted 19-Feb-13 1:41am
josh-jw15.1K
Comments
Ankur\m/ 19-Feb-13 6:54am
   
You question is not very clear. What do you mean between a and s?
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

Here 's your required query

select * from table where locname between 'a%' and 's%'
order by locname

Enjoy & happy coding Smile | :)
  Permalink  
v2
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Do you want all the location that starts with a and ends with s?

If yes, here's the query.

select * from table where loc LIKE 'a%s'
  Permalink  
v3
Comments
Ankur\m/ 19-Feb-13 6:53am
   
Reported as 'not an answer'.
Use 'Have a Question or Comment?' widget to post question/comment to a question rather than posting an answer.

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.160208.1 | Last Updated 19 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