GSquared, thanks for the reply! I am testing your implementation, it is a much different concept than what I was using and I think it has solved a few other...

Yes it is very possible for an address to be in the Zip field, but it does not happen all that often. The majority of the data is valid, around...

Thank you for you reply. Yes we do have a process to parse out the locations of postal codes (which we also are refining) but anything that looks like a...

We import the disparate files into this table, row by row (with column headings from text files, xls, csv, etc)

[Code]

CREATE TABLE [dbo].[raw](

[tableID] [int] IDENTITY(1,1) NOT NULL,

[col001] [varchar](500) NULL,

[col002] [varchar](500)...

Hello, thank you for replying! Yes we currently look at records one by on, because we receive inconsistent data files from many different sources, and these data files change their...

If you want to be super accurate you can use this as your like string. It includes only the proper letters currently included in Canadian postal codes (taking in account...