Home » Developer & Programmer » Reports & Discoverer » Delete unwanted records (disc 10.1.2)
Delete unwanted records [message #383160] Tue, 27 January 2009 07:42 Go to next message
aarti81
Messages: 235
Registered: December 2007
Location: USA
Senior Member
Hi all
I have a report which has "contratc number" as one of the fields, and it has the following data:
DC10061
DC10047
DC10056
DC10025
9914222
8923655
0891065
What i want is to see only the records that do not have the 'DC' prefix. Any help is great.

Thanks
Re: Delete unwanted records [message #383164 is a reply to message #383160] Tue, 27 January 2009 08:01 Go to previous messageGo to next message
vivekbhatt23
Messages: 5
Registered: January 2009
Location: delhi
Junior Member

you can use in the where condition

where contract_number not like 'DC%'
Re: Delete unwanted records [message #383166 is a reply to message #383164] Tue, 27 January 2009 08:11 Go to previous messageGo to next message
aarti81
Messages: 235
Registered: December 2007
Location: USA
Senior Member
Hey Vivek, thanks i tried that option but no luck it is still showing the records with the 'DC' prefix.
vivekbhatt23 wrote on Tue, 27 January 2009 08:01
you can use in the where condition

where contract_number not like 'DC%'

Re: Delete unwanted records [message #383178 is a reply to message #383160] Tue, 27 January 2009 09:34 Go to previous message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Why don't you show us the full query. And what happens if you run it in sql+?
Previous Topic: REP-1212 error message
Next Topic: INSTALLING DISCOVERER 10G ON BUSINESS VISTA
Goto Forum:
  


Current Time: Thu Mar 28 14:49:38 CDT 2024