seperating text from numbers in a varchar
Posted: Tue Jul 09, 2002 10:44 am
how can i seperate characters from numbers in a varchar?
for example if i have a varchar in sql with the data hello123 how can i out put it so that it will seperate it into two variables $textstuff and $numberstuff?
anyhelp would be g8ly appreciated.
Thanks

for example if i have a varchar in sql with the data hello123 how can i out put it so that it will seperate it into two variables $textstuff and $numberstuff?
anyhelp would be g8ly appreciated.
Thanks