Breaking News: Grepper is joining You.com. Read the official announcement!

compare field sql server

Add Answer

dr4ft answered on February 24, 2021 Popularity 8/10 Helpfulness 3/10

answer compare field sql server

related How to compare two columns in SQL server

related compare fields sql

compare field sql server

Comment

SELECT 
  CASE WHEN COLUMN1 = COLUMN2 
    THEN '1' 
    ELSE '0' 
  END 
  AS MyDesiredResult
FROM Table1
INNER JOIN Table2 ON Table1.PrimaryKey = Table2.ForeignKey

Popularity 8/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: compare field sql sql-server

Link to this answer
Share Copy Link

Contributed on Feb 24 2021

dr4ft

0 Answers Avg Quality 2/10

Closely Related Answers

How to compare two columns in SQL server

Comment

SELECT CASE WHEN REPLACE (Table1.ColName1,'.','') = Table2.ColName2 
            THEN 'Equal' 
            ELSE 'Not Equal' 
            END AS IsEqual
    FROM Table1
    INNER JOIN Table2 ON Table1.PrimaryKey = Table2.ForeignKey

Popularity 9/10 Helpfulness 3/10 Language sql

Source: sqlerrors.com

Tags: compare

Link to this answer
Share Copy Link

Contributed on Sep 14 2022

thecodeteacher

0 Answers Avg Quality 2/10

compare fields sql

Comment

SELECT field1, field2, IF(field1 = field2, 'Same', 'Different') AS Status 
FROM table

Popularity 9/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: compare

Link to this answer
Share Copy Link

Contributed on Oct 25 2022

Taha Zouhair

0 Answers Avg Quality 2/10

compare field sql server

Contents

More Related Answers

compare field sql server

Closely Related Answers

How to compare two columns in SQL server

compare fields sql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.