<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2719.2200" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=275433416-07022003><FONT color=#0000ff size=2>NameBadge:
=IIF(IsNull(RequestorName),BadgeNumber,RequestorName&"/"&BadgeNumber)</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><FONT color=#0000ff size=2></FONT> </DIV><!-- Converted from text/rtf format -->
<P><SPAN lang=en-us><B><FONT color=#0000ff>Charles Wortz</FONT></B></SPAN>
<BR><SPAN lang=en-us><FONT color=#0000ff>Software Development
Division</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>Texas Education
Agency</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>1701 N. Congress
Ave</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>Austin, TX
78701-1494</FONT></SPAN> <BR><SPAN lang=en-us><FONT
color=#0000ff>512-463-9493</FONT></SPAN> <BR><SPAN lang=en-us><FONT
color=#0000ff>CWortz@tea.state.tx.us</FONT></SPAN> <BR><SPAN lang=en-us><FONT
color=#000000>(SELECT * FROM users WHERE clue > 0)</FONT></SPAN> </P>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Hollis,Virginia
[mailto:HollisVJ@pgdp.usec.com] <BR><B>Sent:</B> Friday 2003 Feb 07
10:31<BR><B>To:</B> 'accessd@databaseadvisors.com'<BR><B>Subject:</B> [AccessD]
Remove extra characters concatenate<BR><BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=380322616-07022003>I am concatenating
two fields Name / badge for a report, this is done in the
query.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=380322616-07022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=380322616-07022003>RequestorName&"
/ "&BadgeNumber</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=380322616-07022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=380322616-07022003>In reports if the
requestor is Null, I do not want the slash between the name & badge number
to show. How can I have the / not show for null requestors?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=380322616-07022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=380322616-07022003>Virginia</SPAN></FONT></DIV></BODY></HTML>