Using WIldcard Caharacter in Kdb

Community Support
1

Say I want to retrieve all price data for times starting with 1420* (e.g. time=1418234533892319745).

I (unsuccessfully) tried:

select price from Table where time=14201% select price from Table where time=14201*
select price from Table where time=14201%
select price from Table where time=14201*

2

see other thread.

select price from Table where string[time] like “14201*”

although why would you want to do this? You can construct a far more
efficient query by using numbers/within:

select price from Table where time within
(1420100000000000000;1420199999999999999)