topic Re: Using Like in Select Query in Application Development and Automation Discussions

Using Like in Select Query

Former Member — Wed, 23 Jul 2008 12:12:58 GMT

Hi all

I am new to ABAP so i don't know how relevant the question is.

I have a variable say svar.

I want a select query using LIKE that helps me fetch data that starts with svar.

Something like 'ABC%'.

The only thing here is that it is a variable so i cannot use: 'svar%' or svar+'%' or anything like that.

Kindly suggest.

Thanks and Regards

Avinash

Re: Using Like in Select Query

JozsefSzikszai — Wed, 23 Jul 2008 12:15:38 GMT

hi,

your variable has to contain 'SVAR' and %, than it will work:

WHERE field LIKE variable

varibale's value is 'SVAR%', all records will be selected where field starts with 'SVAR'

hope this helps

Re: Using Like in Select Query

Former Member — Wed, 23 Jul 2008 12:15:55 GMT

hi check this..

PARAMETERS srch_str(20) TYPE c.

CONCATENATE '%' srch_str '%' INTO srch_str.

DATA text_tab TYPE TABLE OF doktl.

SELECT *

FROM doktl

INTO TABLE text_tab

WHERE doktext LIKE srch_str.

% is for single char

is for string of char

Re: Using Like in Select Query

Former Member — Wed, 23 Jul 2008 12:16:51 GMT

Hi Avinash,

Change the variable name. In the select query just search with 'svar%' or svar+'%' . After the select query you can pass it into the variable. Try it out.

Regards,

Swapna.

Re: Using Like in Select Query

former_member195383 — Wed, 23 Jul 2008 12:19:37 GMT

u can use like in the select query.

But if u want the comparision to be done with a variable..then u can not use like in that case.

one thing u can do..If u know the postioning of the letters in the table field that are to be compared with the var1. then u can achieve this. Supose u want to compare 4 characters in the table field starting with the 3rd digit.

then in the where condition u can write something as...

where zfield+2(4) = WF_VAR1.

Re: Using Like in Select Query

Former Member — Wed, 23 Jul 2008 12:25:09 GMT

Check the sample ././

How to use the LIKE in select statement

REPORT  ZTEST_SIMPLE.

data: svar(4).
data: it_flight type sflight_tab1.
svar = 'A%'.


select * from sflight
into table it_flight
where carrid like svar.

break-point.

Re: Using Like in Select Query

Former Member — Wed, 23 Jul 2008 12:25:38 GMT

I tried the same thing but it gave an error that no such field exists.

What I mean is if I modify the field on which the search is based..it says no such field exist.

Re: Using Like in Select Query

Former Member — Wed, 23 Jul 2008 12:30:00 GMT

Thanks everyone, a small error on my part also.

Yes If I append the variable by the wild card character it works...

I was doing a small mistake with that.

Re: Using Like in Select Query

Former Member — Wed, 23 Jul 2008 12:30:47 GMT

Can you post the code.

so that i can see what is the error.

Re: Using Like in Select Query

laszlo_kajan2 — Thu, 02 Jun 2022 13:15:20 GMT

sql_cond - LIKE:

``The use of the wildcard characters "_" and "%" corresponds to the standard of SQL.``

SQL LIKE:

Wildcard character Description Example

% Any string of zero or more characters. WHERE title LIKE '%computer%' finds all book titles with the word 'computer' anywhere in the book title.

_ (underscore) Any single character. WHERE au_fname LIKE '_ean' finds all four-letter first names that end with ean (Dean, Sean, and so on).

Re: Using Like in Select Query

former_member974711 — Mon, 04 Sep 2023 05:05:25 GMT

SELECT CASE

WHEN pac.PAC_NOME LIKE 'RN%' THEN ESP.ESP_COD = 'PED'

ELSE ESP.ESP_COD

END ESPECIALIDADEID

-- v.ESPECIALIDADE as especialidadedescricao,

-- 'O' AS fonte

FROM

PAC

INNER JOIN HSP ON HSP.HSP_PAC = PAC.PAC_REG

INNER JOIN v_esp_medico v ON hsp.hsp_mde = v.MEDICO

INNER JOIN esp ON esp.ESP_NOME = v.ESPECIALIDADE

INNER JOIN LOC ON LOC.LOC_COD = HSP.HSP_LOC

INNER JOIN STR ON STR.STR_COD = LOC.LOC_STR

INNER JOIN SMK ON hsp.hsp_proc1 = smk.smk_cod

WHERE HSP_dthra >= :data_ini

AND hsp_dthra <= :data_final

SQL Error [42000]: [-5015] (at 68): Missing keyword:END

BECAUSE?

Re: Using Like in Select Query

moshenaveh — Mon, 04 Sep 2023 05:06:33 GMT

Hello,

While we're happy that you've come to SAP Community to get an answer to your question, you posted your question as an answer in an old thread.
I've converted your answer to a comment, but even so -- posting in older threads is not the best way to get guidance.
If you're looking for help, you should ask a new question: https://answers.sap.com/questions/ask.html.
Here are some tips to help you craft an effective question for our community: https://community.sap.com/resources/questions-and-answers, https://developers.sap.com/tutorials/community-qa.html, https://groups.community.sap.com/t5/welcome-corner-discussions/advice-from-sap-champions-questions-and-answers/m-p/123609.
I encourage you to follow this guidance, as I'd really like to see you get a solution to your problem.
I hope you find this advice useful!