Stringing Name parts together

[JrClown]

How do I take a set of name parts such as prefix firstname middle name lastname suffix and make a full name field with spaces between each field taking into account when prefixes are blank and middle names are blank QUOTE OF THE DAY
The only ideas that will work for you are the ones you put to work.
<%
Jr Clown
)
%>

 

[MiggyD]

Which version are you using??

II
III
III+
IV
5

 

[JrClown]

Version IV sometimes 5 QUOTE OF THE DAY
The only ideas that will work for you are the ones you put to work.
<%
Jr Clown
)
%>

 

[murry26]

try

@ 0,0 SAY RTRIM(FIELD1) + &quot; &quot;+IIF(ISBLANK(FIELD2),&quot;&quot;,RTRIM(FIELD2)+&quot; &quot)+ IIF(ISBLANK(FIELD3) etc .etc

 

[MiggyD]

Guess that did it, murry26. Good job. --MiggyD

Never be afraid to try something new. Remember that amateurs built the Ark. Professionals built the Titanic.