Query Items by specific letter or higher

[Moebius01]

I was working on a small project and came across this idea, but wasn't sure if it was doable.

Is there a way to select items that start with a given letter or higher? For example,

select * from table where LOWER(item) LIKE 'g%'

would give me all items starting with the letter g. However, what if I needed to simply start at g and pull all items that start with g - z? Is there an easy way to do this that my fried brain is overlooking?

 

[Moebius01]

Sratch that. My brain came online shortly after posting and used a quick conversion to ASCII to do the job.

 

[tshot]

why convert ? simply write

select * from table where LOWER(item) >= 'g' ;

----------------
ur feedback is a very welcome desire

 

[hos2]

perhaps

select * from table where LOWER(substr(item,0,1)) >= 'g' ;

is better then or is 'aa' not greater then 'g'

 

[Moebius01]

Strange, when I tried the >= the first time it didn't seem to work, so I went with the ASCII. Guess I'll give that another go. Must have been another typo in the statement that caused nothing to return.

 

[tshot]

accoring to my knowledge string comaprison is ascii values and in our case comes to lexicographic. also each char of 1st string is matched with corresponding char of 2nd string. hence 'aa' is smaller than 'g' in dict order but grater length wise.

If length is the criteria then ur optin is a better method and i comaprison is cii based then mine wold work equally well




----------------
ur feedback is a very welcome desire