Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Posts
    24

    Unanswered: Finding Matched String With Blank Spaces

    I need to find a matched string with blank spaces. For example, an input string is "matchedstring" and a string of "matched string" in DB will be returned. How to write a select statement for this type of match?

  2. #2
    Join Date
    Aug 2003
    Location
    West
    Posts
    101
    select
    field_name
    from databasetable
    where replace(field_name,' ', '')='matchedstring';

Posting Permissions

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