Due to a design flaw, I have a "Time" textbox field on my asp.net form, where users enter the length of their songs. This allows them to enter time however they choose, where I should have used validation to force mm:ss. With that said, I'd estimate that 99% my records are in that format or are null.
Now I need to query and get all songs under 30 seconds. Can I do this considering that these values are stored as text in SQL Server? Also, how do I ignore records that aren't in the proper format or are null? Thanks