I have a third part stored procedure I need to update.
There's a variable that's arriving as varchar
It then needs to be declared numeric
The problem is that it's a phone number and I need toi strip out the invalid characters to populate the numeric field.
Peeople at times put dashes and other times dots or ()
Little help here?
By the way...I've been told to update the sp and NOT touch any of the ColdFusion or ASPX vb code
Comes in as
@phone varchar(25),
blah...blah...blah...
Declare @newphone numeric
blah...blah...blah...
if @phone <> null set @newphone = @phone
Start Free Trial
