Sorry for the multipost. I only pressed send once, and it came up two times. Again - Sorry

I think I read of SQL-NS or anything lookalike to those things inside EM. I

might use that then!

--

Our company is using the MD5 algoritm. You can insert the SSN into an application and you get a 128-bit "fingerprint" or "message digest" of the input.

Another thing that came up!

Runniing this on a server - LTG_ARBST:

BACKUP DATABASE abw_SWBS_200k  TO DISK = '\\LTG_ARBST\Felles\Data\Temp_LTG.BAK' RESTORE FILELISTONLY  FROM DISK = '\\LTG_ARBST\Felles\Data\Temp_LTG.BAK'  RESTORE DATABASE abw_SWBS_200k_a  FROM DISK = '\\LTG_ARBST\Felles\Data\Temp_LTG.BAK' ...

select * from Item2 where RegDate >= '2004/09/18 11:15:00' and ItemNo = '0000002'.

I would like this select not to include the first two and only the one that is nearest...

Are there no other way around? What about if sentence or anything?

I was thinking of using T_SQL cause that the text file might change from time to time. Sometimes it might be six columns and perhaps 20. I was thinking of...

When using the import Wizard in SQL server - you don't have any of the PK and IX transferred. At least this is what I have seen. Am I correct?

Why...

When using the import Wizard in SQL server - you don't have any of the PK and IX transferred. At least this is what I have seen. Am I correct?

Why...

When using the import Wizard in SQL server - you don't have any of the PK and IX transferred. At least this is what I have seen. Am I correct?

Why...

When using the import Wizard in SQL server - you don't have any of the PK and IX transferred. At least this is what I have seen. Am I correct?

Why...

Does it really look like Access Design  - it is created in Access - and ported to SQL Server.

The link you referred to was a...

I'm trying to change the column yes!

I'm having several tables - which I would maintain at the sime time.

Was actually thinking of a job that I could run to maintain the databases - but I can't...

Thanks - but here is a similar function; and easier to understand

SELECT RIGHT(Replicate('0',5) + CAST(512 AS varchar(5)), 5)