Have you considered converting the integer to a fixed-length character string, using CAST or CONVERT, prior to encryption?

Steve

(aka smunson)

:):):)

If you can create a result set that for each item, also has the quantity or frequency of that item, and if you can use SQL 2005, you can then...

Now I see where you're at. It wasn't obvious to me from looking at your T-SQL that the potential for a heirarchical relationship beyond option and product beyond...

Try using LIKE, perhaps as follows:

SELECT DATA_VALUE

FROM MY_TABLE

WHERE DATA_VALUE LIKE '% %'

Note there is a single space between the two percent signs.

Steve

(aka smunson)

:):):)

want_to_know (6/3/2008)

I have values like this:

10003 ...

How about using SQL Server 2005's UNPIVOT operator? See if something like the following might help:

SELECT [Date] AS DateKey, Customer AS CustomerKey,

Location AS LocationKey,...

Take a look at the following code that can demonstrate a technique that uses an auxiliary table of numbers:

-- START WITH A TABLE OF THE NUMBERS FROM 1 to 200

SET...

I'm glad you were able to figure it out. I was having trouble understanding why you needed a not equal relationship, as I would have thought that any...

Leave the parameter as an integer, and change the query to check for:

QExpiry.FieldName <= DATEADD(d, @DateOffset, GETDATE())

You should be able to have this work in both locations.

Steve

(aka smunson)

:):):)

Here's the help on the "freetext string" that goes into the FREETEXT function, which explains about quoted strings:

freetext_string

Is text to search for in the column_name. Any text, including words,...

I need to know more about how you plan to keep track of what options have been selected. Are you updating any permnanent table with this information? ...

I saw similar things happen with Excel imports in SQL Server 2000, where if the data in the first several rows LOOKED like a particular data type, a row far...

Hmmm... it appears I'm way behind on information on memory capacity and the ability to get past the 4 GB addressing limit of 32 bits. Can anyone...

I'm not familiar with the term BCP, but given that temporary tables are generally attached to the session that creates them, I'm thinking we need to know more about why...

Yes, Jeff... you're quite right. Being a newbie to both SQL Server 2005 (although an oldie to SQL Server 2000) as well as this forum, my excitement...

Umm... I may not be recalling this correctly, but I haven't seen anyone ask what Server OpSys is in use, and I did see the indication that SQL Server is...