Hello, i am looking for sql server equivalent function for this ...
Could some one help me ...
thanks, sujiPHP Code:
function removealphas (byval alphanum as variant)
dim clean as string dim pos, a_char$ pos = 1
if isnull(alphanum) then
exit function f
or pos = 1 to len(alphanum)
a_char$ = mid(alphanum, pos, 1)
if a_char$ >= "0" and a_char$ <= "9"
then clean$ = clean$ + a_char$
end if
next
pos removealphas = clean$
end function