String functions, such as MID() need to know where the substring you’re extracting begins and ends. When that information is unknown or inconsistent from one value to another, you’ll have to ...

which almost worked until i realized they don't actually match on strings, which misses some of the rows. From what I've been able to gather, using REGEXP_SUBSTR could be a way to go, but I just ...

Is it possible to order by a substring in a returned field ... I can't think of how I'd do this in SQL, but before I give up and just write code to deal with it, can someone else come up with ...

If you ever need to sort character strings ... article applies to SQL Server 2000 and later.) @fullstring VARCHAR(1000), @charlocation1 TINYINT, Now that I have my helper function, I can write ...