I don't know anything about DB2 but in SQL Server
SELECT TOP 1 * FROM mytable
WHERE PartNumber LIKE '851251-403%'
ORDER BY DatetimeStamp DESC
>I need help with SPT to db2 database file.
>
>Suppose I need the status of a part number 851251-403.
>
>Alpha codes(suffixes) are used to specifiy color. Business logic says that the part in a series with the latest datetime stamp, no matter the color, drives the part number status.
>
>In my status database I have two records 851251-403 and 851251-403A these have a datetime stamp field and the 851251-403A has the latest datetime stamp.
>
>What would be the SPT syntax to find the 851251-403A record while passing the 851251-403 within my where clause?
--sb--