Parsing and trimming strings using SQL
We have a shop that has appended alpha characters to standard part codes.
We need to run a compare query between part codes in other tables and those
in this shop's table, but the alpha characters at the end of their codes
need to be removed before the codes can be compared. The codes vary in length
and some have internal alphas, but all codes properly end in a number. Do
you have a transact query for removing all the alpha characters at the end
of a string for each field in a column? We are using SQL Server 6.5.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL