I'm new to SQL - however - we push tables from a MAS data base. The fields in the table are all string (character) fields, we need some of these fields that are numbers to be formatted in our SQL table as a number. What is the best way to accomplish this task?
Usually using these fields in Crystal Reports we would use the tonumber function.
Thank you for your help!!!