I am trying to ORDER BY a column that is a varchar data type, but it has numerics and slashes in it. It is not ordering it correctly, any ideas? I would like it to sort in numerical order, then after the numerics, sort in alphabetical order. lHere are the values being returned in ascending order:
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…