SQL Server Performance

like in sql 2000

Discussion in 'Getting Started' started by Ur1, Nov 17, 2007.

  1. Ur1 New Member

    need to get string itmes that have 'XY' only in the middle from a table. my 'like' doesn't seem to work right.
    XYZ has XY is the only one ok.
    XYZ has XZ is not ok.
    XYZ has YZ is not ok.
    XYZ is a my word is not ok.
  2. Madhivanan Moderator

    [quote user="Ur1"]
    need to get string itmes that have 'XY' only in the middle from a table. my 'like' doesn't seem to work right.
    XYZ has XY is the only one ok.
    XYZ has XZ is not ok.
    XYZ has YZ is not ok.
    XYZ is a my word is not ok.
    [/quote]
    Your question seems unclear to me. Can you post some sample data and the result you want?

Share This Page