I would like to have a query replace a NULL in a field with a truncated value from one field based on a size passed in? Basically, I'd like to be able to generate a 'short title' for a record based on either the user's input for a short title, or a turncated 'normal title' at query time. Would this be very expensive processor timewise? I might just feed the whole long title in and have the display properties of the browser truncate it. Dennis Gearon Signature Warning ---------------- EARTH has a Right To Life, otherwise we all die. Read 'Hot, Flat, and Crowded' Laugh at http://www.yert.com/film.php -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general