> On Thursday 07 December 2006 16:34, Ed Reed wrote:
>> Thanks for the quick reply Chris.
>> It's close but it's a little off. Your example also returns all
>> instances that where the letter N exists in another words as well
> SELECT SUBSTRING(value,2) as value_num, value FROM num_test WHERE value
> like 'N%';
> Though this wouldn't work if you had like Night or NIGHT. Is that going to be
> a choice?
You'll need a regex, see these...