I need to compare data between 2 fields (actually more but the solution to 1 will work for all). The values in these fields are intended to be money type data but the website stores the data as text and does not validate the data so there are often times vaules such as NA, $, ^ and other non numeric characters. My plan is 2 fold, 1-remove the non numeric characters and then 2-use the convert function to covert the data to INT from the varchar that it is now. Then I will be able to compare the data. The goal is a stored procedure that will have a select statement that I can display as an output. The output form could be a VB form, Access Form, web page etc but I don't think that matters as long as I have a Select statement within the stored procedure that can be passed to the form.
Start Free Trial
