declare @test table (col1 numeric(10,4))

insert into @test

SELECT 34.0200 UNION ALL

SELECT 1232.0560 UNION ALL

SELECT 234.4400 UNION ALL

SELECT 451232.123

select * from @test

where col1 like '%.__[1-9]%'

This does do an implicit conversion...

CirquedeSQLeil (4/22/2010)

---

Thanks.

I like the comment he made...

A picture's worth a thousand words, but setup code is worth more. If you can provide the tables structure via CREATE TABLE statements, and some sample data via INSERT statements,...

Actually, I think you will find that most people...

Grant Fritchey (4/22/2010)

---

jcrawf02 (4/21/2010)

---

GregoryF: "don't worry about not knowing how many instances/servers there are, every where I have ever worked, no one know all of them, there are some that...

Gianluca Sartori (4/22/2010)

---

Jack Corbett (4/22/2010)

---

Gianluca Sartori (4/21/2010)

---

I've seen even worse things in my app (Visual Basic):

Public const SC AS String = "'" 'Yes, you got it right, it's...

Hugo Kornelis (4/22/2010)

---

Good question. Not sure why it's worth 2 points; knowing that TRUNCATE can be rolled back should be elementary knowledge.

Abrar Ahmad_ (4/22/2010)

---

[font="Verdana"]Goodish, easy hunt. but for the only...

GregoryF (4/21/2010)

---

jcrawf02 (4/21/2010)

---

GregoryF: "don't worry about not knowing how many instances/servers there are, every where I have ever worked, no one know all of them, there are some that are...

Well, keywestfl9 did say:

i have a requirement to find median of two date column in...

ColdCoffee (4/21/2010)

---

Guess...

andy behrendt (4/21/2010)

---

Hi All,

I have a stored procedure that requests one parameter which is a bit field. In the stored procedure I want to check if the parameter is...

How's this?

DECLARE @Date1...

That was indeed a novel way to start...

Might I suggest instead of just...

You actually sleep??? When did this change occur? :w00t: