app, I don't have access to the SQL Server for ease of manipulation and they
want to see it tomorrow. It will be run once a day and relevant to about
4,000 records. Any other input would be greatly appreciated.
Tony
-----Original Message-----
From: Paul Hastings [mailto:[EMAIL PROTECTED]
Sent: Monday, February 09, 2004 11:14 PM
To: CF-Talk
Subject: Re: SQL Pickle
> I have one field in a database (SQL Server 2000) that contains a comma
> separated list of state abbr. (AL,CA,TX). I am submitting ONE state
> selection (CA) for example to a query. I simply need to go to the database
> and select records CONTAINING 'CA' within the comma delimited list..
that's a perfectly awful way to handle this. re-design your app, put the
states data in another table, one per row. everything will become simpler.
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]