Thanks for the information.  Things are a little clearer now .

This is already going to be intergrated to some point.  You will be able to dbl-click on any id field to drill down one level and see that info (assuming...

Keep in mind that this solution doesn't work (is not 100% reliable) if the stats are not up to date.

Also keep in mind that no rows in the table does not...

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"