hey guys,

I solve it by:

WHERE
CASE
WHEN @ddl='ModelName' THEN ModelName
WHEN @ddl='ModelNo' THEN ModelNo
END
=@tb
Thanks for help
Wish to know other method if u have other ideas,
thanks

__________________
The KINGMAKER
Makes Every Thing Possible

Stuffs (My Blog)