Help with SQL statement for Field that is empty string

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.

## Deliverables

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.

## Platform

Microsoft SQL Server 2000

Habilidades: Engenharia, MySQL, PHP, Arquitetura de software, Teste de Software, SQL

Veja mais: string i, field engineering, sql microsoft, MICROSOFT SQL SERVER, sql statement stored, php sql 2000, working string, name empty, sql statement help, sql run package, sql email, empty, zero email server, SQL stored, null software, email sql, help current, zero distribution, email address engineering, package sql distribution, sql 2000, sql sql, last modified program, tables stored sql, php sql tables

Acerca do Empregador:
( 172 comentários ) United States

ID do Projeto: #2967120

Concedido a:


See private message.

$6.99 USD em 1 dia
(11 Comentários)