print text instate of number in sql code example
Example 1: sql query print strings and int
print 'There are ' + cast(@Number as varchar) + ' alias combinations did not match a record'
Example 2: sql query print strings and int
print 'There are ' + convert(varchar,@Number) + ' alias combinations did not match a record'