What data type i can use for combination of string and number: HPMdb 0000119

[kmk]

Hi Mates,

i want to execute SQL command to get based on filter so using Execute a SQL Query, there i need to filter with a field value

ex: filter in ID field where Id=HPMDB 0000119

SELECT ID,FROM
     Table
WHERE
    (ID ='HPMdb 0000119')
-----------------------
SELECT ID,FROM
     Table
WHERE
    (ID ='@{outputs('Compose')}')

 i can get expected values from the first query, but not from the last/next query because its combination of string, number

what is the data type can we use for combination of string/number 

yes i also tried taking variable, with string datatype but it throws error since it contains numbers as well.

your help will be highly appreciated 

[ManishJain]

Hi @kmk ,

If you are doing looping and using the fields , try using compose action and specify your inputs with expression. 

Thanks