Set NoCount On

Create Table #X(N Char(1))

Insert Into #X Values('A')

Insert Into #X Values('a')

Select

*

From #X

Where ASCII(N) = 65 --Use the value rather than convert it ASCII('A')

--Select * From #x

Drop Table #X

Not...

Try adding dbo. in front of it.

If you look in the list of functions in EM, is it there?

Cheers,

Crispin

quote:

---

im write, customer wrong.

---

How many times has this happened?

Cheers,

Crispin

Text between to tags is just that, Text.

Open the dicument with IE or XML Spy. If both of them render the document, what you have is fine.

You could, for...

Kleb, I did a couple tests awhile ago between the two types.

Differences become apparent when you work with large tables (1000's or rows)

It might have been the topic I had...

Another easy way is to use a function to split your string.

I have a functin called SplitString which requires a string and a delimiter. It returns a table.

Then use:

Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
 

Hi Phill,

I guess I should have added in the software settings etc.

Both are SQL 2k with SP3a.

MDac would both be whatever came with SP3a.

Raid on dev is hardware (Cache unknown)

Workstation...

A decent place to start is http://www.w3schools.com/

Have a wide selection of various languages.

Cheers,

Crispin

You got users for those functions? I got developers for those functions...

Was thinking. How about a SQL assistant? It can hover around EM and QA.

Cheers,

Crispin

ha ha!

No, I have yet to see it be useful.

God help us the day it gets promoted from Office Assistant to Windows Assistant!

Cheers,

Crispin

hmmm, I'm gonna have to trust you on this one as I do not have a table with a couple million rows.... 🙁

I agree that if you taking a couple...

While the plan is as you said, have a look at the times. Dynamic SQL is expensive. Fastest option is still having the OR's.

UDF becomes the slowest.

Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!