>>Forget it.
>>Sorry.
>
>Yes Yes Yes Yes Yes .. ??
>
>kidding of course. Cheers,

Cheers :)

How can I do:

declare @CategoryPrice smallmoney
select @CategoryPrice = select Price from PriceInfo where CreditCategory = @PassedCategory

select 'CT' as State, @CategoryPrice as Price, CreditType, county, 
registry, city, address, def1FName, Def1LName 
from CTCredit..CreditInfo where CredID in 
(select CredID from CartDetail 
inner Join CartContent on 
CartDetail.CartContentID = CartContent.CartContentID 
and CartContent.State = 'CT' and CartContent.CreditCategory = @PassedCategory )

Is it right?