What are the challenges you face when working across database platforms? Take the survey

Is If-Then-Else logic possible

Suppose I have two columns and I want column 2 to be based on the random value from column 1.  For example, column 1 is Yes|No.  I'd like column 2 to be 1 when column 1 = Yes and 0 when column 1 = No.  Is this possible?  I am new to regex expressions and tried to search online for examples, but what I found doesn't seem to work in SQL Data Generator. 

Thanks for your help and suggestions!



Sign In or Register to comment.