So I was handed a VERY complex script simply to turn into a pipe delimited file. The problem is that I cant seem to trim anything that used substring. for ...

I have an assignment to modify my last project (written using SQL Server) to include a whole host of things, including complex data types and table inheritance. Can SQL Server do these things, or ...