Get rid of special characters when pulling a SQL field
Posted on 2004-08-11
How do I get a field from a table and get rid of all the $ . or ,? AND is this right to get rid of the / in date of a field in sql?
The example I am using is from VB and I need this to work in VB.net.
1: field to get rid of $ . and , are:
2: the fields from SQL are inv_dat and rpt_date:
invdatebat = Format(rst!inv_dat, "mmddyy")
rptdatebat = Format(rst!inv_date, "mmddyy")
Thanks in advance for the help.