I want to so something like the following:

```
SELECT * FROM TABLE1
WHERE DATE1 LIKE DATE2 + '%'

```

However, when I try this I get the following error:

"5407: Invalid operation for DateTime or Interval"

I am working in Terdata SQL Assistant