Thats Sweet! Thanks again.
Joe.
>Hi Joe,
>
>You're welcome. BTW, you wouldn't have to trim variables if you DECLARE them varchar instead of char.
>
>>All I had to do was trim up the vars and viola!
Thanks!
>>>Hi Joe,
>>>You've to build SQL string and than execute it with EXECUTE command or
>>> sp_execute sql system stored procedure.
>>... snip ...
>>
>>Thanks again,
~Joe Johnston USA
"If ye love wealth better than liberty, the tranquility of servitude better than the animated contest of freedom, go home from us in peace. We ask not your counsel or arms. Crouch down and lick the hands which feed you. May your chains set lightly upon you, and may posterity forget that ye were our countrymen."
~Samuel Adams