Click here to Skip to main content
13,001,686 members (95,229 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 i need to retrieve location between 'a' and 's'.all the location having value between a and s .
Posted 19-Feb-13 0:41am
Ankur\m/ 19-Feb-13 6:54am
You question is not very clear. What do you mean between a and s?
Rate this: bad
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 :)
Rate this: bad
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'
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
Web02 | 2.8.170624.1 | Last Updated 19 Feb 2013
Copyright © CodeProject, 1999-2017
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