Community

Testing for Valid Data Representation in SQL

How can I tell if a character column contains a valid representation of numeric data? I have a column expression in a Select statement that needs to convert character Column A to numeric only when it contains a valid numeric representation. If Column A doesn’t contain a numeric representation, then

Read More - Register for Free Membership

Tags: