We have this view, but I'm not sure the best way to send it? SELECT TOP (100) PERCENT ObjectID AS ID, ObjectNumber, SortNumber, ObjectName, Dated, Title AS [Scott Number], Medium, CreditLine, Description, dbo.Concat_LocationString(ObjectID, 1) AS Location, ObjectCount FROM dbo.Objects AS O ORDER BY SortNumber Caitlin Badowski TMS Administrator Smithsonian National Postal Museum 2 Massachusetts Avenue NE, MRC 570 Washington, DC 20013-7012 (202) 633-8735 [log in to unmask]<mailto:[log in to unmask]> [NPM Logo for Signature Block] From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Rob Morgan Sent: Friday, April 01, 2016 11:24 AM To: [log in to unmask] Subject: Current Location in a List View Hello TMS Community, Has anybody successfully placed current location in a list view? If so, can you send me the SQL script? Thanks everyone, Rob Morgan Collections Database Administrator The Baltimore Museum of Art To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed. To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed.