Is it possible to order by a substring in a returned field?<BR>I've got a query which returns at most probably around 10 or so rows of 1 column. However the way this data is formated, it'd be convient ...

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 example I have tried all of these with no ...

The next version of SQL Server, Microsoft’s flagship database product, will launch on June 1, the company announced today. The release follows Microsoft’s usual round of public previews and release ...

When it comes to improving the performance of database systems, there are nearly as many approaches as there are DBA (database administrator) teams. That might sound acceptable at first glance. But, ...