SQL 'IN' Statement

Reply Subscribe

Thread Tools

Search this Thread

May 5, 2007 | 05:11 PM

djuk

Thread Starter

Scooby Regular

Joined: Jun 2002

Posts: 1,280

Likes: 0

From: Berkshire

SQL 'IN' Statement

I'm trying to figure out how to use the contents of a cell in Excel to populate a SQL IN statement but can't figure it out. Does anybody know if this is possible?

Using a standard IN statement works fine...

Code:

SELECT *
FROM CRMtest2.dbo.AgendaItems AgendaItems
WHERE (Region IN ('East','West'))

And using one based on a cell works fine if theres just a single value in the cell...

Code:

SELECT *
FROM CRMtest2.dbo.AgendaItems AgendaItems
WHERE (Region IN (?))

But when I enter multiple values like this...

The query fails

Any ideas welcome

May 5, 2007 | 08:24 PM

Dracoro

Scooby Regular

Joined: Sep 2001

Posts: 10,261

Likes: 0

From: A powerslide near you

you need to seperate the valus in the cells. as it stands, it's ONE string rather than 3. You need a way to seperate them out, putting in the single ' quote marks appropriately. I'll let you figure out how to do this

but it's not that difficult. beware of single quotes within strings tho

May 5, 2007 | 09:26 PM

J4CKO

Scooby Regular

iTrader: (1)

Joined: Jan 2003

Posts: 19,384

Likes: 1

Generate the whole select statement including the cell value as a text string and then run it, you will as Dracoro has said have to format the string with single quotes.