>>The RAISEERROR supports only integers for %d/%i. You'll have to convert your numeric value to a string and use with %s modificator.
>
>:-) Thanks for confirm me what I was thinking!
>
>So, I have 'updated' my function like this:
>
>
>Declare @Var1 Integer, @Var2 numeric (9,2), @Var2s VarChar(10)
>Set @Var1 = 1
>Set @Var2 = 123.45
>Set @Var2s = Ltrim(Str(@Var2,9,2))
>RaisError('Var1 = %i Var2 = %-s',16,1,@Var1, @Var2s)
>No need of LTRIM(STR(....)) if you CAST the variable to varchar()
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
