• Compassionate (3/5/2013)


    No, @f1 has only underscore as the special character reamining all are letters/digits.

    Could you please explain more on RAISEERROR with sev 10?

    You can add calls to RAISERROR with a severity of 10 or less which will send an informational message to the output stream.

    Here is a generic call that sends a literal string to the output stream:

    RAISERROR('Custom informational message.', 10, 1);

    Another way to call RAISERROR that might be useful in your case is to use tokens to send variable values to the output stream, like this:

    RAISERROR('@f1 = %s', 10, 1, @f1);

    What's happening in the above statement is that the value of @f1 is being substituted into the place of the token %s, which means "a string value", within the message before it is sent to the output stream There is a different token for numbers, %d, and some other tokens for different data types as well. Unfortunately there is no token for date or time values.

    You can read more here:

    RAISERROR (Transact-SQL) - SQL Server 2005

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato