Posts:
Malte has not published any posts yet.
Replies:

Well, the result is not always the same: I just found out that you should be careful when working with :variables, for example in %SQLQuery:

select 1 where 'well...' %startswith :myvar

Returns 1 row for myvar being null.

Whereas

select 1 where 'well...' like :myvar||'%';

Does return no row for myvar being null.

Using IRIS for Windows (x86-64) 2021.1 (Build 215) Wed Jun 9 2021 09:56:33 EDT

Followers:
Malte has no followers yet.
Following:
Malte has not followed anybody yet.
Global Masters badges: