I need a sql statement to be modified to return email address instead of last name if last name is null or a zero length string = "" . I have included tables and current stored procedure which only works if field is null but does not handle the zero length case. I need the distinct set like it currently returns.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
Microsoft SQL Server 2000