UT excellent job with the DDL and sample data;
does this give you the results you are looking for?
SELECT
ID,
TTYpe,
TTime,
COALESCE(NULLIF(TFunction, ''), TStatus) AS FunctionStatus
FROM MyTransactions
ORDER BY
TTime
Lowell
--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!