Re: Compare Fields in the Same Table

From: Aaron Bertrand - MVP (aaron_at_TRASHaspfaq.com)
Date: 05/19/04 

Date: Wed, 19 May 2004 17:30:43 -0400

What do you mean by "compare"? How similar do you expect two separate TEXT
columns in the same row to be? 

-- 
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Josh Gerszewski" <josh_g20@hotmail.com> wrote in message
news:u32RUfePEHA.3052@TK2MSFTNGP12.phx.gbl...
> Hi Everyone,
>
> I'd like to compare two text fields in the same table using a select
> statement but I'm having a hard time with the query. Here is what I need
in
> pseudocode!
>
> Select * from Table where behavior like alternate_behavior
>
> Thank you in advance! Any help is greatly appreciated!
>
> Josh Gerszewski
>
>

Relevant Pages

  • Re: Compare Fields in the Same Table
    ... If you only want identical matches, ... "Josh Gerszewski" wrote in message ... >> SQL Server MVP ... >>> I'd like to compare two text fields in the same table using a select ...
    (microsoft.public.sqlserver.programming)
  • Re: help me on this audit trail trigger
    ... INSERTED and DELETED tables and compare the rows as Dan has suggested. ... David Portas ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Does Yucon support set ansi_nulls?
    ... So if I have to compare fields for inequality then the ... Can I Know the exact maximum limit of query string allowed? ... > SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Exclude Spaces
    ... Dan Guzman ... SQL Server MVP ... I want to compare two cloumns n two different tables excluding spaces. ...
    (microsoft.public.sqlserver.server)