locked
where statements v spaces RRS feed

  • Question

  • User2074931137 posted

    where s.Contact.ContactResourceTypeString != "Van"

    The code above filters the records to show all records where the ContactResourceTypeString is not equal to the word "Van"

    The code below does not filter the records as above.  The only difference I can see is there is a space between the two words within the quotation marks. 

    where s.Contact.ContactResourceTypeString != "Driver Assistant"

    How do I filter the records on a value that contains a space?

    Wednesday, December 5, 2018 3:44 PM

Answers

  • User-474980206 posted

    the space is treated as any other character. maybe there are two spaces or a tab in the compare string.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, December 5, 2018 3:55 PM

All replies

  • User-474980206 posted

    the space is treated as any other character. maybe there are two spaces or a tab in the compare string.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, December 5, 2018 3:55 PM
  • User2074931137 posted

    thanks Bruce...typos.  My mistake.  Thanks

    Wednesday, December 5, 2018 4:04 PM