Need help to exclude ' from query
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Need help to exclude ' from query

  1. #1
    Join Date
    Jul 2001
    Posts
    334
    Hi all,

    I want to exclude from our table all ' . For example we have stored in one of the column Int'l. We do not want all those rows in which ' exists. Can any one help me?

    Thanks in advance

  2. #2
    Join Date
    Aug 2000
    Location
    Ny
    Posts
    105
    Your "WHERE" in part should look like this:

    WHERE COL_1 NOT LIKE '%''%'

  3. #3
    Join Date
    Jul 2001
    Posts
    334
    Thanks Highlander it works perfect.

    I like your WS.

    Thanks
    aph

Posting Permissions

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



Click Here to Expand Forum to Full Width