topic Re: Select where % in Application Development and Automation Discussions

Select where %

Former Member — Thu, 07 Jun 2007 06:39:28 GMT

Hi All,

Why is the below statment not fetching any data?

SELECT * FROM t012k INTO TABLE gt_t012k WHERE bankn EQ '%15%'.

Data is present in the table T012k having bankn = %15%.

Thanks,

Rakesh.

Re: Select where %

sreeramkumar_madisetty — Thu, 07 Jun 2007 06:40:59 GMT

SELECT * FROM t012k INTO TABLE gt_t012k WHERE bankn EQ '%15%'.

Use :

SELECT * FROM t012k INTO TABLE gt_t012k WHERE bankn LIKe '%15%'.

Regards,

Sree

Re: Select where %

Former Member — Thu, 07 Jun 2007 06:42:14 GMT

SELECT * FROM t012k INTO TABLE gt_t012k WHERE bankn like '%15%'.

regards

shiba dutta

Re: Select where %

former_member196280 — Thu, 07 Jun 2007 06:44:06 GMT

When you want to USE % in where clause use LIKE.

Regards,

Sai Ram

Re: Select where %

Former Member — Thu, 07 Jun 2007 06:44:30 GMT

In SQL the symbol % is used to get LIKE fields

say 'AB%' means all fields starting with AB to be fetched.

Ensure that there is data in the table with this field '%15%'. then

Declare a constant

Constants: v_bank like t012k-bankn value '%15%'.

data gt_t012k like t012k occurs 0 with header line.

then see the select statement:

SELECT * FROM t012k INTO TABLE gt_t012k

WHERE bankn = v_bank.

Reward points for useful Answers

Regards

Anji

Re: Select where %

Former Member — Thu, 07 Jun 2007 06:44:46 GMT

How can i use LIKE % FOR ALL ENTRIES?it is giving error

Re: Select where %

Former Member — Thu, 07 Jun 2007 06:45:19 GMT

Rakesh,

Use LIKE '%15%'

Thanks,

Raj.

Re: Select where %

Former Member — Thu, 07 Jun 2007 06:50:24 GMT

With character type variables u could use co(contain only) cs(contain string) ..

Thanks

Dinesh