Hi all
What command do I use to strip an sql table column of everything but numbers? Let's say I have values in my column such as "NX-383_H" and I only want the number portion "383" in the column but want to discard the other junk? What command do I use? thanks J __________________________________ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]