Link to home
Start Free TrialLog in
Avatar of metropia
metropiaFlag for United States of America

asked on

remove special character from column

I have a question.

There is a column named: Shipping Time, and it has a data type of varchar(32)
but when I run a select to see the values of this column, I see that the value is stored as:

User generated image

I would like to learn if possible through asking this question,  how to convert, or replace that special character that I have not seen before.

For your help, thank you very much.
Avatar of David L. Hansen
David L. Hansen
Flag of United States of America image

Will the returned good characters always be a single digit or could they be larger integers?
Avatar of metropia

ASKER

the largest number would not pass the two digits
The the largest possible value would be 9?
ASKER CERTIFIED SOLUTION
Avatar of David L. Hansen
David L. Hansen
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Did that work?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial