Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Jaderwannabe
  • Order by date
  1. Jaderwannabe

    SQL Server select with equal criteria returns unexpected results

    Thanks for the fast responses and the lit links.. i'll check them out. Learn something new everyday- usually the hard way ;-)
  2. Jaderwannabe

    SQL Server select with equal criteria returns unexpected results

    LNBruno: it is defined as varchar(6),NULL Crowley16: I was searching for the ones that were entered incorrectly 'SL8' is right 'SL8 ' is not. So I was looking for all the correctly entered ones. in essance the statement did the rtrim for me when i didnt want it to.
  3. Jaderwannabe

    SQL Server select with equal criteria returns unexpected results

    select asset_id from asset_oth_bk_depr where b3_depr_mthd_cd = 'SL8' order by asset_id commit select asset_id from asset_oth_bk_depr where b3_depr_mthd_cd = 'SL8 ' order by asset_id commit select asset_id from asset_oth_bk_depr where b3_depr_mthd_cd = 'SL8 ' order by asset_id commit select...

Part and Inventory Search

Back
Top