Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dus512
Starting Member
1 Post |
 Posted - 2007-10-23 : 15:34:55
|
| Hello --I can handle this task quite easily in SQL Server, but I do not know how to do this for Access. I have a column of data in Access that is primarily used to store numeric data; however, the column has several rows of data that have non-numeric content. In addition, the numeric data often has commas and dollar signs and these need to be stripped (but, decimals need to stay in place).In Access, how can I write a query to read each row of data and remove the non-numeric characters (excluding decimals)?Sample Rows of Data:Column name: MonthlySalary; Table name: JobDetails$13,002.23N/ATBA9,053Thanks for any help you can provide!Scott |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-10-24 : 01:37:26
|
Have you tried the ISNUMERIC function yet?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
|
|
|
Converting non-numeric data to numeric in Access