Thank you very much
Jim

>Jim,
>
>The CASE in T-SQL is a finction not the flow control statement. For the flow control you would use IF ELSE statrement as shown below
>

IF @BOOK = 'ALL' 	BEGIN
>	IF (@Type = 'ALL')  THEN
>			BEGIN	
>					PRINT 'ALL Skus, ALL Types'
>	END	
>
>	ELSE IF (@Type IN ('ntrReceipt','Trans','SC' )  OR @TYPE2 IN ('ntrTransfe','ntrReceipt','SP') )THEN
>					BEGIN
>						PRINT 'All SKUs, Receipt, Receipt'
>					END
>									
>	ELSE IF (@TYPE = '2') THEN
>					BEGIN
>						PRINT ' All SKU''s, @Type = 2'
>						END
>	END
>
>END
>
>ELSE
>...

In the future please enclouse code between < pre> and < /pre> tags (w/o spaces) for readability.
>
>
>>I did read BOL
>>
>>
>>I would like to simplify a complexed stored procedure useing CASE Statements
>>The following code gives me the following errors.
>>
><snip>