With your data
Contains(dbcode, '"3*"')  will return all the rows (providing each code you posted is in a separate row)
Contains(dbcode, '"*3*"') will not return any rows as the * prefix...

I tested your code and it returned your expected results.

Contains(dbcode, '"*3*"') is the valid FTS format, however you cannot use * as  a prefix as it is used...

DECLARE @value varchar(20) =

1. The update should be in the trigger there is no need for an additional procedure
2. The UPDATE statement will update every row in the JOURNAL table not just...

Grant Fritchey (1/11/2017)

Brandie Tarvin (1/11/2017)

So someone tell me who those "Steve Jones" and "Grant...

If you output your data as tab delimited to an .xls (not .xlsx) file

Excel will be able open the file if you accept the prompts (depending on version of Excel)

Notwithstanding Thom's reply.

If you can change the data then include page number, output the invoice data with odd page numbers and a single row of null values with even page...

WITH x (ID,FirstName,LastName,UserName,UserNum) AS (

SELECT e.ID,e.FirstName,e.LastName,LEFT(e.FirstName,t.N)+e.LastName,

ROW_NUMBER() OVER (ORDER BY LEN(LEFT(e.FirstName,t.N)+e.LastName) ASC,LEFT(e.FirstName,t.N)+e.LastName ASC,ID ASC)

FROM #Employee e

JOIN master.dbo.Tally t ON t.N BETWEEN 1 AND LEN(e.FirstName)

WHERE NOT EXISTS (SELECT * FROM #TEMP_USER u...

Oh well it was close 😛

Notwithstanding Eirikur's statement re same first names

WITH x (ID,FirstName,LastName,UserName,RowNum) AS (

SELECT e.ID,e.FirstName,e.LastName,LEFT(e.FirstName,t.N)+e.LastName,

ROW_NUMBER() OVER (PARTITION BY e.ID ORDER BY LEN(LEFT(e.FirstName,t.N)+e.LastName) ASC)

FROM #Employee e

JOIN master.dbo.Tally t ON t.N BETWEEN 1 AND LEN(e.FirstName)

WHERE...