Birst JOIN not respecting case

Lisa Callahan

How do I make sure Birst respects the case when joining in Prepare? The only way I can join two archived tables is on a field that uses camel case. For example, I need to join using

LEFT OUTER JOIN "S3_L_HAPI" ON "S3_L_HAPI"."L_INDEX"="S3_APINVOICE"."L_INDEX"

where the L_INDEX field = 'zIMY' or 'zimy' or 'ziMY'

Birst must be converting everything to upper because I am getting all combinations of those 4 letters, not just 'zIMY'

Please and thank you!

Diane Mcelhiney

Birst string comparisons are case-insensitive because of the collation used. If you only need rows where the match condition meets these 3 values, you have to account for them in the Script portion of the Scripted Source. And you have to be creative.

IF Substring([L_INDEX],0,3) = 'zIMY' THEN transformations, etc, along with other columns and writerecord ENDIF.