Format SQL query return col

Question

I have a col ProductName in my Select statement which has a String which has a attached string "-Sales" for e.g. peter -Sales. Now I want my result to remove that -Sales and just show peter. How can i do it.I am just pasting my select part of my query as my query has many inner join

SELECT
dbo.Customer.firstName+' '+dbo.Customer.lastName        AS FirstName,
 CONVERT(VARCHAR(10), dbo.Receipt.receiptDate,105)       AS SaleDate,
dbo.Receipt.transactionNumber AS TransactionNumber,
dbo.Receipt.description        AS ProductName,

Will it always be -Sales or do you want to strip out everything after the last -? — MatBailie
– MatBailie, Commented Nov 14, 2012 at 9:36

John Woo · Accepted Answer · 2012-11-14 09:31:23Z

3

you can use REPLACE

SELECT REPLACE(dbo.Customer.firstName+' '+dbo.Customer.lastName, '-Sales',''),...
FROM...

answered Nov 14, 2012 at 9:31

John Woo

265k70 gold badges509 silver badges500 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Format SQL query return col

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related