have to have the last word don't you ?! okay - worked equally fine with <= 4!

darn but you stole my idea noel - have been saving parsename for just such an occasion as this...btw - sometime in the past (many moons ago) - i did...

pete - your best bet seems to be creating and running a scheduled dts package -

one way of doing this : you could append half of what you're doing...

maybe if you explained the process some more.....???

eg: - what functionality are you converting to t-sql ? why do you have a foxpro table ? what is the sequence of...

Assuming I've understood your requirements correctly - yes, this is possible:

If this is a one-time thing using the wizards would be the quickest way.

1) create table in sql server with...

Andrew's suggestion of newid maybe the solution then...here's something from BOL on Unique indentifiers and the pros & cons...

Using uniqueidentifier Data

The uniqueidentifier data type stores 16-byte binary values that operate...

Basit - I don't believe there's any way to directly print the query results without first copying or exporting it to a program (formatting - ie notepad, excel, word etc..)...

doesn't take care of the nulls and spaces though...

this might do the trick..

INSERT INTO tblDestination

SELECT CASE

WHEN LEN(cardNum) > 0 then REPLICATE('*', 12)+ RIGHT(cardNum, 4)

ELSE NULL

END

FROM tblSource

You can do this several ways:

1) in query analyzer, you can choose - under tools - options - results tab - "results to file" from the first dropdown box...save to...

Nicklous...there're many ways to skin this cat...here's one:

DELETE FROM TABLE WHERE LEFT('icqrm006520050406142936mxfs100100995-icqrm006520050406142936mxfs100100995',(CHARINDEX('-', 'icqrm006520050406142936mxfs100100995-icqrm006520050406142936mxfs100100995', 1)-1))

=

RIGHT('icqrm006520050406142936mxfs100100995-icqrm006520050406142936mxfs100100995',(CHARINDEX('-', 'icqrm006520050406142936mxfs100100995-icqrm006520050406142936mxfs100100995', 1)-1))

You can also - in EM - go to the table properties and click on the "relationships" tab to view the foreign key constraint....

that's because your select only has the "AccountInfo, SpaStartDate " fields - add "SpaId" to it and run again.....

I couldn't have put it better myself...

Eric - "it would be so much neater on row 11...."

is ONLY FOR DISPLAY PURPOSES...

you don't really care how SQL stores these values internally so long as you're able...

Christopher - I think what you want to do is to have the DateHired column DEFAULT to the date that the employee is hired...

change your table def to :

create table...