SQL for WILDCARD searching
937334May 27 2012 — edited May 28 2012Good Day,
Hi MASTER's got a little problem
got a table
DIESEL_DETAIL
___________
DATE_PO
PLATE_NO
DRIVER_NAME
I NEED TO SEARCH HERE'S MY QUERY
SELECT * FROM DIESEL_DETAIL
WHERE TO_CHAR(DATE_PO,'DD-MON-YYYY')
BETWEEN :P1_FROM
AND :P1_TO
AND PLATE_NO = :P1_PLATE_NO
OR DRIVER_NAME = :P1_DRIVER_NAME
ITS WORKING PERFECTLY BUT ITS MUST HAVE A VALUE
WHAT I WANT TO TO IS WHAT IF THE USER NOT INPUT THE VALUE
IT WILL AUTOMATICALLY EXECUTE THE WILDCARD SEARCH
IF THERE'S A POSSIBLE WAY?
THANKS MASTER'S GOOD DAY..