Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    3

    Unanswered: concatenate 2 fields and compare with third one

    Hey,

    Can u tell me how do i concatenate fields
    eg :
    table1 : address_bk
    Area_code char 3
    phone char 7

    table2 : phone
    tel_no char 10

    I want to concatenate both the fields in table1 , compare the results with table2 tel_no field and delete records from 1st table which are present in 2nd table...!

    I use VB 6.0 as front end and SQL 7.0 as backend..!

    thanx,
    Twinkle

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    delete from address_bk
    where Area_code+phone in
    (select tel_no from phone)

    rudy
    http://rudy.ca/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •