filtering the numeric and alphanumeric values
-
i have a column of datatype string in the sql server 2000 database. following is the data in that table 1 2 11 12 a if i sort the data then output comes in the following manner 1 11 12 2 a , but i want 1 2 11 12 a to sort out this problem i thought to make two unioun queries to fileter the numeric values and alphanumeric values. no the questio is can somebody tell me how to filter the numeric and alphanumeric values .
Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.
-
i have a column of datatype string in the sql server 2000 database. following is the data in that table 1 2 11 12 a if i sort the data then output comes in the following manner 1 11 12 2 a , but i want 1 2 11 12 a to sort out this problem i thought to make two unioun queries to fileter the numeric values and alphanumeric values. no the questio is can somebody tell me how to filter the numeric and alphanumeric values .
Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.
Don't double post, it's rude.
#region signature my articles #endregion