Hi, what is the sql statement to convert a varchar to a number. I'm trying to run a query that grabs all prices that are either less than, more than, or equal to a value but need to convert those values first. Currently, the prices have commas in them such as 100,000 and I need them to return like 100000. My database is ms sql server 2000.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.