Gosh. This is a long time ago.

I'd forgotten all about this until I got an email from smorgan just now. And I can barely remember anything about it, so my...

What if the table has...

Something along these lines?

declare @t table (v varchar(50))

insert @t

select '10.1.1.%'

union all select '10.%'

union all select '10.1.%'

union all select '99.%'

union all...

I'm not clear on the goal. Could you write it out for your sample data so we have a clear example?

if exists (select * from table where nullif(column, ' ') is null)

print 'column contains either a null or a space'

else

print 'column contains...

Here are a few possibilities...

declare @t table (id int, v varchar(50))

insert @t

select 1, '654:JT12;678:JT56;'

union all select 2, '6549:JT129;6789:JT569;453:JT435;'

select *,

...

select * from Table where not (FirstName = 'Jimmy' and LastName = 'Woods')

Replace all instances of < with &lt; to post your XML...

Try replacing every < with &lt; before posting...

Here's my effort. I was assuming there could be multiple messages in #t1, which makes it a bit trickier. I'm not proud of it, but anyway...

--Sample Data

--drop table #t1

create table...

No worries - glad to help 🙂

Huh? Did you see the not symbol (^)? Here's an example...

--Sample Data

declare @t table (v varchar(100))

insert @t

...

My understanding is slightly different. Here's what I came up with...

set dateformat dmy

--Sample Data

declare @t1 table (EMPID int, WEFDATE datetime, DEPTID int)

insert @t1

...

Here's an example of the cube root of 27...

select POWER(1.0 * 27, 1.0 / 3)

Will this work?

select * from YourTable where YourColumn like '%[^a-zA-Z0-9]%'