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

Populate Based on Another Field

garyk1968garyk1968 Posts: 2
edited July 13, 2015 12:32PM in SQL Data Generator
Hi,

I have five address fields (addr1,2, 3 etc.) and for the first line I am only populating it with a value 50% of the time.

What I would like to do is only populate addr2, 3, 4 and 5 if addr1 has a value.

Not sure how to go about this?

Thanks


Gary

Comments

Sign In or Register to comment.