Select where %

[Former Member]

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.

[sreeramkumar_madisetty]

Hi

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

Use :

SELECT * FROM t012k INTO TABLE gt_t012k WHERE bankn<b> LIKe</b> '%15%'.

Regards,

Sree

[Former Member]

SELECT * FROM t012k INTO TABLE gt_t012k WHERE bankn <b>like</b> '%15%'.

regards

shiba dutta

[former_member196280]

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

Regards,

Sai Ram

[Former Member]

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

[Former Member]

Hi

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

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

data gt_t012k like t012k occurs 0 with header line.</b>

then see the select statement:

<b><b>SELECT * FROM t012k INTO TABLE gt_t012k

WHERE bankn = v_bank.</b></b>

Reward points for useful Answers

Regards

Anji

[Former Member]

Rakesh,

Use LIKE '%15%'

Thanks,

Raj.

[Former Member]

hi

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

Thanks

Dinesh