I am having a very trying time trying to get a print statement to work with a conversion. I have verifed that when the query is run, there is data in the @PrevailingWage parameter. None of the following have worked. What am I missing?
I have tried adapting the following from a previous post:
Any help would be greatly appreciated.
Bill
Code:
print 'Prevailing ' + Convert(varchar (10), @PrevailingWage)
print 'Prevailing ' + Cast(@PrevailingWage as varchar)
print 'Prevailing ' + Coalesce(@PrevailingWage, '')
I have tried adapting the following from a previous post:
Code:
/*
select @f,convert(numeric(38,2),@f),
convert(varchar(66),convert(numeric(38,2),@f))
*/
print 'pw' + (Select @PrevailingWage,
Convert(numeric (6,3), @PrevailingWage),
Convert(varchar (8), convert(numeric(6,3),@PrevailingWage))
Any help would be greatly appreciated.
Bill