Results 1 to 2 of 2

Thread: How to check if a given text is found in a table

  1. Jun 12th, 2003, 07:28 PM #1
    PT Exorcist
    PT Exorcist is offline

    Thread Starter
    yay gay PT Exorcist's Avatar
    Join Date
    Apr 2002
    Location
    . . . my reason of shame
    Posts
    2,729

    How to check if a given text is found in a table

    i have a SELECT statement in mssql that searches in a column for "WEB_PAGE" but its raising an error and i believe its because there is STILL nothing on it that has "WEB_PAGE"..how do i check my table if it has something before doing the DELETE statement?
    \m/\m/
    Reply With Quote Reply With Quote
  2. Jun 12th, 2003, 07:49 PM #2
    powdir
    powdir is offline
    Addicted Member
    Join Date
    Feb 2002
    Location
    closed
    Posts
    196
    an error shouldn't be raised simply because the search fails to find a match. For that matter it shouldn't error if you try to delete a record which isn't there either. Check your SQL, or post it so i can have a look.

    Cheers
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width