Solved Issue in using query as source

Hi,

I facing issue while executing query as source.
In my table data like

emp_id
001
002
003
004
em1
emp2
zy

I want to fetch only those records which start with numbers

So I am using below query and which is executing properly
select emp_id from emp
where emp_id like '[0-9]%'

but when I use above query as source query then stambia removing data which is written under square bracket ('')

guide me to resolve above issue


Note : Even in this editior whatever written inside square bracket is getting deleted.

Regards,
Prashant

Hello Prashant,

I observe the same behavior as you. Can you try doubling the square brackets ?
I'll ask the dev team the reason for this necessity. I guess it is related to some feature, I will tell you.[code generation] feature, I will tell you.

Hello Thomas,

Thanks for your reply

yes 2 square bracket is working fine.

Regards,
Prashant