Selasa, 22 Juni 2010
TSQL Beginners Challenge 10 - Clean up alphanumeric strings by splitting digits and letters into separate columns
This challenge refers to sanitizing text data. Your task is to read an alphanumeric string and create two output columns one containing all the digits found in the input string and the other with all the letters of the English Alphabet. Sample Input DataId AlphanumericData-- ---------------------------------------------------------------------1 I would like to invite my readers to participate in
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar