Select statement with in ISNULL?

2 AFAIK NULL! = NULL – NullUserException? Sep 30 '10 at 4:30 @NullUserException, sorry, you're right.IS NULL is what you want... – Dean Harding Sep 30 '10 at 4:34.

Assuming the @TransactionTypeID will always return a value: SELECT @v_FilePrefix = COALESCE(@v_FilePrefix, TransactionTypePrefix) FROM ConfigTransactionType WHERE TransactionTypeID = @TransactionTypeID COALESCE will return the first non-null value. If @v_FilePrefix is not null, it will just set the value to itself. But it would be best to use: IF @v_FilePrefix IS NULL BEGIN SELECT @v_FilePrefix = TransactionTypePrefix FROM ConfigTransactionType WHERE TransactionTypeID = @TransactionTypeID END.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.