SQL weird

Discussion in 'Software' started by be0, May 24, 2007.

  1. be0

    be0 Corporal

    Here are 2, as it seems to me, identical statements:

    select cus_no, ship_to_name, ship_to_addr_3 from OEHDRHST_SQL
    where cus_no like '%F0%' and ship_to_addr_3 like '% FL %'


    This statement Returns 333 rows.

    SELECT
    OEORDHDR_SQL."cus_no", OEORDHDR_SQL."ship_to_name", OEORDHDR_SQL."ship_to_addr_3"
    FROM
    "DATA"."dbo"."OEORDHDR_SQL" OEORDHDR_SQL
    where cus_no like '%F0%' and ship_to_addr_3 like '% FL %'

    This one returns 1 row.

    ???? I am clueless to the differences here.....
     
  2. be0

    be0 Corporal

    Never mind...
    I noticed that the tables are different...
    IDIOT!!!!
     

MajorGeeks.Com Menu

Downloads All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ PC Games \ System Tools \ Mac/Apple/Ipad Downloads

Other News: Top Downloads \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds