QSQL - BETWEEN text

https://learninghub.kx.com/forums/topic/qsql-between-text

I have an issue with SQL for kdb+ .

After execution:

.s.e"SELECT * FROM trips
WHERE payment_type BETWEEN 'CASH' AND 'DISPUTE';

I get an error:

length. can’t execute ?[+`date`month`vendor`pickup_time`dropoff_time`duration`passengers`distance`start_long`start_lat`end_long`end_lat`payment_type`fare`surcharge`tip`tolls`total!(`s#2009.01.01 2009.01.01 2009.01.01 2009.01.01 2009.01.01 2009.01.01 2009

Have you experienced an error like that ?

Hi @macius222

Thank you for reporting this! I will investigate further into why this error is occurring in the demo.

Many thanks,

Megan