I have the results of a system sproc that give me the date and time (as seperate fields) something ran.So I have the time last run as: 180001 I need to convert that to something more like 18:00:01 ...

Anyone know how to work with commas and apostrophes coming in as input from a form, and inserting this data into a record using SQL in ASP? If the user enters data with an apostrophe into a text ...