BIO12345-A -Wifey BIO12345-B -Life and Times of Collins BIO12346 -Madeline BIO12347 -Cooking with Betty BIO99999-A-San Francisco Superstars BIO99999-B-San Diego Superstars BIO12348 -The Life of PI
SELECT Title, FileID, FileID + ' - ' + Title AS TitleIndo FROM Library_Info
like '%'+char(13)+'%'
like '%'+char(10)+'%'
SELECT Title, FileID, LEFT(LTRIM(FileID)+SPACE(13),13) + ' - ' + Title AS TitleIndo FROM Library_Info
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)