just paste something like that for each table.

create table #granted(grantedid int,grantedname varchar(30) )

insert into #granted(grantedid,grantedname) values (1,'Lowell')

insert into #granted(grantedid,grantedname) values (2,'Remi')

insert into #granted(grantedid,grantedname) values (3,'Frank')

insert into #granted(grantedid,grantedname) values (4,'Noel')

then repost...

The tablename is wrong or you didn't specify the right owner (try changing to your user name if the table name is correct).

What causes that problem to come up in the first place?

That thread is not over, we requested you send us the code you were using so we could help and you didn't do it so we're still on hold on...

Update dbo.YourTable set DatCol = SUBSTRING(DatCol, 9, 2) + '/' + SUBSTRING(DatCol, 6, 2) + '/' + SUBSTRING(DatCol, 1, 4)

I can't help you if you don't post the data and table definition.

What's wrong with that?

Can you paste the script to recreate the tables/index/relations and insert some sample data. I'll build it for you on my pc yif you can send me this.

No, just wondering if that would have worked and what would have been showed (too lazy to recreate the situation ).

[EDITED]

oops wrong thread.

ELECT is short for SELECT

6 is the start position, 2 is the length to retrieve..

Check SUBSTRING in the books online for more...

Can you check the ascii value of that character? If it's not 49 then that's where you're problem is.

ELECT???

Pasting problem Farrell?

Yes but answer this first, why would you keep a date in a text field?? Doesn't that seem wrong to you?

That's why I spread the words... found that out too about 1 month ago.

Why not keep it as a date?