Web Development

Ask something
Question Locked

Query - SQL/ Ms Access

0 helpful
2 replies

by solshakdwn

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
does anyone have an idea how to change short names to full name using a query or other tool to change database names e.g. Dan - Daniel, bill - William.

2 replies

by john.a.wills

The decode function should do it, although you'd have a great big list of shortened versions and full versions to put in. Also, 'Dan' is not always an abbreviation for 'Daniel', it can be a name in its own right - as well as being a short form of Danielle or Daniela. I think your problem is really unsolvable, because information is lost in the act of abbreviation.

This discussion is closed to new replies.