Wouldn't it faster to run if exists (Select * from ?) instead of count(*)???

You might want to check it out more closely, it appears that many more characters are allowed than I first taught.

Build a ascii table with all characters and see for...

IF OBJECT_ID ('tempdb.dbo.#Demo') > 0

 DROP TABLE #Demo

GO

CREATE TABLE #Demo (ID INT NOT NULL IDENTITY(1,1), Name VARCHAR(50) NOT NULL)

INSERT INTO #Demo (Name)

SELECT '0123456789'

UNION ALL

SELECT 'abcdefghijklmnopqrstuvwxyz'

UNION ALL

SELECT 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'

UNION ALL

SELECT '0.a'

UNION ALL

SELECT '0,a'

UNION...

This is a pattern match using double negativity :

NOT LIKE '%[^a-z0-9A-Z]%')

=

NOT (any character outside a alphabetical letter or number returns true)

So even a space in that pattern match will...

SELECT * FROM dbo.Table WHERE ColName NOT LIKE '%[^a-z0-9A-Z]%')

This returns all VALID data.  Space and punctuation signs are considered invalid in this search, you can simply add them at the...

That seems to be somewhere along the lines of what I wanted to do (on the how to heck to do this side).

I wanted to build a list of paths...

A natural key would be a SSN instead of an identity column.  The SSN is a natural key because it is a unique identitfier for the person (by country... not sure it...

Come on... make a Joe Celko out of you .

Thanks for the quick feed back.

So you want to cast a date to a string to do comparaisons (useless work)!!!

Or even worse, case the date to 1900/01/01 which is a valid data, which can return...

Thanks for the assist .

Can you post the printed statement?

Hey Peter, can you tell us what your signature is supposed to represent?

E 12°55'05.76"

N 56°04'39.42"

You can always add an identity column and use that as uniqueidentifier to delete the tuples, then drop the column.

Create perm table (exact match)

insert ValidData into newtable

drop old table

rename new table

rebuild...

Also there are easier ways to clean out data.

If you want, we can check for another solution, but we need the table definition (with keys) and what determines the row...

That's certainly one reason.

I've never actually tried this but I think it can work.  Thanks for letting me know.

You can do this to correct the problem :

(

dbo.flightinfo.end_date = b.end_date

OR

dbo.flightinfo.end_date IS...