13,001,686 members (95,229 online)
Rate this:
See more:
`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 0:41am
josh-jw17.2K
Ankur\m/ 19-Feb-13 6:54am

You question is not very clear. What do you mean between a and s?

Rate this:

## Solution 2

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

Enjoy & happy coding :)
v2
Rate this:

## 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'`
v3
Ankur\m/ 19-Feb-13 6:53am

Use 'Have a Question or Comment?' widget to post question/comment to a question rather than posting an answer.

Top Experts
Last 24hrsThis month
 OriginalGriff 290 ppolymorphe 180 Bohdan Stupak 115 F-ES Sitecore 110 Dave Kreskowiak 60
 OriginalGriff 4,857 ppolymorphe 2,437 RickZeeland 2,221 Kornfeld Eliyahu Peter 2,031 Richard Deeming 1,643