Parenthesis in field value

Hello all

I have a table called PRODUCT and the unique field in the table is called PARTNUMBER like so:

PARTNUMBER DESCRIPTION
12345(6) Widget 1
12347(5) Widget 2

my select SQL looks like this
SELECT * FROM PRODUCT WHERE PARTNUMBER = '12345(6)'

That statement fails. what can I do to get around this error?

Regards
The CaptainThe only obvious thing I can think of is that you should use the double quotes and not the single quotes.

This works in SQL View in Access:

SELECT PRODUCT.*, PRODUCT.PARTNUMBER
FROM PRODUCT
WHERE (((PRODUCT.PARTNUMBER)="12345(6)"));|||How does the statement fail? Does it produce an error message?

-PatP

Parameterized filters

Hi all;
I know that Parameterized filters allow different partitions of data to be
sent to different Subscribers without requiring multiple publications to be
created (parameterized filters were referred to as dynamic filters in
previous versions of SQL Server). A partition is simply a subset of the rows
in a table; depending on the settings chosen when creating a parameterized
filter, each row in a published table can belong to one partition only
(which produces nonoverlapping partitions) or to two or more partitions
(which produces overlapping partitions).
I need some examples and good resources talking about this.
Any suggestions
Apart from BOL, and the 2 books mentioned in my home page
(www.replicationanswers.com) I don't think you'll find a great deal of
specific material on this. Are there any particular questions you want to ask
about the setup?
Paul Ibison