Recent content by jbright00

Also, thanks to everyone else who gave input. Your ideas were helpful as well.

Thanks a lot George. I think that's exactly what I was looking for. I have a Delphi app that imports a 600+ MB text file into 2 Access databases. I am replacing it with a SQL Server DTS Package. The current process (with the app) is taking 24+ hours to run... so I am certain that even with...

Well, I just need the numeric part. So, if it was Apt. 101 1st Street, I need '1011'. If it is 1st Street, Apt. 101 then I just need '1101'. I am extracting out an "address key" for a lookup system, so this is why the first 4 numeric characters is all I need. Thanks!

The numeric part may or may not be first. It could be for example, PO Box 1234. Is it possible to capture the 1234 part of such a string? Thanks!

I have a char field which contains addresses and I need to extract just the numeric portion and store it in another field. Is this possible? Any help would be greatly appreciated! Thank You.

Thanks a lot! One more question... Is there a way I could have another column telling which of the 2 select statements the value is from?

I have the following query: SELECT Rejects.cDCN,ScanReject.ImageName FROM Rejects FULL OUTER JOIN IDC_ScanReject ON Rejects.iid = IDC_ScanREject.iid The data looks like this: Rejects.cDCN 12345 67890 ScanReject.ImageName 89231 32412 I want this: SingleColumnName 12345 67890 89231 32412...