Results 1 to 8 of 8
  1. #1
    Join Date
    Dec 2005
    Posts
    266

    Unanswered: find space (MS SQL 2005)

    how can I find a space into a string ? (for MS SQL 2005)

    SELECT name FROM tbNames WHERE name LIKE '% % '

    is not working

    thank you

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    what do you mean it's not working? it should

    can you give an example of a name with a space in it where it doesn't work?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Dec 2005
    Posts
    266
    I dont understand ... now it works

    thanks r937

  4. #4
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    sounds like a heisenbug

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Usually when that happens to me it is caused by an id-10-t error.

    -PatP

  6. #6
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by jezemine
    ... heisenbug
    thank you so much, what a gorgeous word, that's brilliant



    pat, see A Truly ID-iotic Design

    Edit: oh hai, it r down atm, plz try again later, kthxbye
    Last edited by r937; 12-01-07 at 15:13.
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  7. #7
    Join Date
    Dec 2005
    Posts
    266
    do you mean it can happen time to time with no reason ?

  8. #8
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    it's not my creation. there are several related ones:

    http://en.wikipedia.org/wiki/Heisenbug

Posting Permissions

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