C O G N OiSe - the COGNOS community  
10 Mar 2010 09:52:56 AM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News: October 1st, 2009 - COGNOiSe.com now on Linkedin with live News Feed!!! Click here to join the group
 
   Home   Help Search Calendar Login Register  
Pages: [1]
« previous next »
  Print  
Author Topic: Filter Out Text  (Read 132 times)
KEKeogh
Full Member
***

Forum Citizenship: +0/-0
Offline Offline

Posts: 18
« on: 09 Nov 2009 12:25:16 PM »
I'm sure I'm missing something simple but I just can't see it.

I have a a report that I want to pull all items where the Desription field does NOT begin with "FYI".


I was thinking [Description] is missing 'FYI' would work but it didn't.

Thanks for the help
Kathie
Logged
Gopinath
Community Leader
*****

Forum Citizenship: +12/-0
Online Online

Posts: 134
« Reply #1 on: 10 Nov 2009 01:39:38 AM »
Hi,

[Description] NOT LIKE 'FYI%' should work.
Logged
Pages: [1]
  Print  
« previous next »
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.4 | SMF © 2006-2007, Simple Machines LLC Valid XHTML 1.0! Valid CSS!