You had a few syntax errors in your code...
There is no trim function in SQL server... only ltrim and rtrim....
Try this:
create table test1
(id int)
insert into test1 values(1)
insert into test1 values(2)
select id_from_test1 = id from test1
select id_from_test2 = id from test2
--drop table test1
drop table test2
--
Dean Savovic
www.teched.hr
Quote:
> Hi everybody,
> I am trying to rename a table dynamically...i tried
> various way, i was still not succefully.
> Could anyboyd pl. help me out on this...
> Thanks
> Jenniffer