Question Where in condition getting syntax error

[sivaksekar]

Hi,

Currently I'm having 5 Million records and trying to get the result from below query

SELECT * FROM AT_OUTBOUND_062017
WHERE CALLING_NBR LIKE in
(201009, 201025, 207259, 2610012, 2611125, 2611914, 2613188, 2615500)

Getting Syntax error (missing operator) in query expression 'CALLING_NBR LIKE in....


Note: CALLING_NBR > Data Type - Number

Kindly ride off this msg to get the expected result.

Regards,
Siva

 

[Minty]

Remove the Like

SELECT * FROM AT_OUTBOUND_062017
WHERE CALLING_NBR IN(201009, 201025, 207259, 2610012, 2611125, 2611914, 2613188, 2615500)