Actually, XQUERY can also update data...

Steve,

How does Timedata compare with database mirroring?

Jeff,

There will be many good, and many bad jobs in your career. What we all need to do is learn to let all the drama wash over us and...

Here's an article I wrote that takes a slightly different tactic for dealing with this issue. I'm not sure if it would have helped in this case, but the...

Was it only running badly with certain parameters, and running correctly with others? Sounds to me like parameter sniffing at work...

Developer contest?? Tell me more...

I was slightly off... Try this instead:

if (@var NOT LIKE '%[^0123456789abcdefghijklmnopqrstuvwxyz]%')

print 'yes'

else

print 'no'

It does work. That's the problem -- it works for EVERY possible numeric datatype -- Integers, floats, money, decimal ... and don't forget binary conversions.

Watch out Mike...

DECLARE @var varchar(20)

SET @var = '1e1'

SELECT 'Yes'

WHERE ISNUMERIC(@var) = 1

http://www.aspfaq.com/show.asp?id=2390

Bimal,

No -- you don't need to replicate anything. Use %[]%.

Simon,

Depending on collation, the characters that fall between two other characters might be different -- it all has to do with sorting...

Compare this:

SELECT CHAR(number)

FROM master..spt_values

WHERE type = 'p'

AND number...

No so fast!

Did you really want special characters from other languages? Maybe. Maybe not.

---

declare @var varchar(10)

set @var = char(226)

print char(226)

if (@var LIKE REPLICATE('[0-Z]', LEN(@var)))

...

+1 for a lucky guess

I live in Davis Square, Somerville (suburb of Boston, right next to Cambridge)... And you're right, prices are absolutely sky high! Too expensive to even consider buying anything right...

I think it's important to note that those numbers are national averages and will vary A LOT depending on locale -- for instance, salary differences between here (Boston) and Denver...