Can anyone tell me how I would represent a hex constant in the where predicate of a filter stage?
var_x = 'E3'xb is the equivalent Teradata expression. And I get the feeling osh will throw up on this.
Thanks.
Using a hex value in the where predicate of a filter stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Conversion before Filter
You mean like with a Modify stage beforehand?ray.wurlod wrote:Convert it to decimal. E3 becomes 227.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: