I'm locking with SQL Spark . I have a column whose values can be:
1) -BF1
2) B -F1
3) X
The sign " -" indicates that any character or string of characters can occupy that position.
My problem is that I need to check whether this rule is in another column , for example :
column1 = BCFDF1LDK
This would apply to the condition 1) record that contains " BF1 "
But do not know how to express this in a where condition :
.where((application_rules("apprul_cd_fare_basis").startsWith("-")===true) && ((locations("fardet_cd_fare_basis")XXXXXXXXXXXXXXXXXXXXXX)))
)
Any ideas?
Aucun commentaire:
Enregistrer un commentaire