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

Tidak ada komentar:

Posting Komentar