SQL Reversing Name String

Results 1 to 3 of 3

Thread: SQL Reversing Name String

  1. #1
    Join Date
    Dec 1969

    Default SQL Reversing Name String

    I have a table which has names displayed as lastname, firstname (i.e. Smith, Joe), but I need the names to be displayed as firstname&#060;space&#062;lastname (i.e. Joe Smith). <BR><BR>Thanks.

  2. #2
    Join Date
    Dec 1969

    Default Ok I won't scold you too

    bad for putting lastname and firstname in one column ; )<BR><BR>Seriously though, IMHO this is bad db design. However, if you want to display it with the reversed order look into using string functions like Mid, Substr, Instr, etc. in your SQL SELECT statement. Look up string functions in your db help.<BR><BR>Now something else to think about. Do you have any names additional names or middle intials in db like<BR><BR>Smith, Mary Jo<BR><BR>or <BR><BR>Jones, John J.<BR><BR>Good luck<BR><BR>Pete

  3. #3
    Join Date
    Dec 1969

    Default or double barrelled name <eop>


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts