how to retrieve the record having space in the record

dataservices job design
1

Hi Experts,

how to retrieve the record having space in the record using SAP BODS

if I write this query in SQL server, I am getting 3 records

select count(*) from [dbo].[sales] where customer_name like ‘%Murali krishna%’

if I apply sample SQL statement through bods, I am getting “0” records.

$G_RowCount = sql(‘DS_SRC’,‘select count(*) from sales where customer_name like ‘"%Murali krishna%"’’);

Please help me, how to call this type of query using BODS script

Thanks for your help

Murali krishna.

ursfriend77 (BOB member since 2011-03-02)