Examples for these ~ same resultset....

By same resultset ~ what I meant was -
The query "select ... from ... where dataConversionFunction(column)..."
will generate a set of records.
I want this to be re-written without the
"dataConversionFunction(column)..." and still give me the same set of
records.
Cheers!On Fri, 27 Aug 2004 04:33:06 -0700, SQLCatz wrote:

>By same resultset ~ what I meant was -
>The query "select ... from ... where dataConversionFunction(column)..."
>will generate a set of records.
>I want this to be re-written without the
>"dataConversionFunction(column)..." and still give me the same set of
>records.
>Cheers!
Hi SQLCatz,
Please provide a real query. Without knowing what you select, from what
tables, which dataconversion function you use and what the rest of the
where clause looks like, nobody will be able to answer your question.
See http://www.aspfaq.com/etiquette.asp?id=5006.
Unless the answer may be as generic as the question, of course:
select ... from ... where column .....
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||See my reply. I have just such example in the article I posted.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"SQLCatz" <SQLCatz@.discussions.microsoft.com> wrote in message
news:DF988A05-5C6B-4D9D-9911-C5F764ECCEBD@.microsoft.com...
> By same resultset ~ what I meant was -
> The query "select ... from ... where dataConversionFunction(column)..."
> will generate a set of records.
> I want this to be re-written without the
> "dataConversionFunction(column)..." and still give me the same set of
> records.
> Cheers!
>