Function contains should be changed in script when used with select.
No change is required when used while filtering the data.
PySpark
df.select(df.col.contains('b').alias('col5')).show()
teradatamlspk
df.select(when(df.col.contains('b'), 1).otherwise(0).alias('col5')).show()