Like in PostgreSql

Classic Servoy
1

Hi

I need create a query for search for example at begining ‘IW’
The problem is there are some items with IWA for example, and I need only IW
I probe that:

select articulo_id from articulos where ref_propia like ‘IW^A-Z%’, but I don´t have nothing

Any idea

Thanks

Servoy 5.2.8
PostgreSql

2

Try the SIMILAR TO operator, it allows you to use regexps: PostgreSQL: Documentation: 9.1: Pattern Matching

3

The correct sentence for make this will be:

For example, if I find all records beginning for ‘IW’ and discriminate the others characters in the string

var query = “select ref_propia from articulos where ref_propia ~ ‘^IW’[^A-Z]’ order by ref_propia”

Thanks

Servoy 5.2.8
PostgreSql