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? -- Chris White PHP Programmer Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
