Remove slash from data and create new field in select query in sql server

Question

I am using SQL SERVER for database related operation in my application.

I have created one view that contains following data:

I want one new field with this view and that field should contains the same data as you can see in Size column in the above view.

But I have to remove coming slash from that data.

Is there any query or function to remove slash from the data in SQL SERVER?

Check out replace()

Raj
– Raj

2017-03-10 06:10:26 +00:00
Commented Mar 10, 2017 at 6:10 — Raj
– Raj, Commented Mar 10, 2017 at 6:10
@Raj Ohh yes it's running. thanks Raj

3 rules
– 3 rules

2017-03-10 06:12:42 +00:00
Commented Mar 10, 2017 at 6:12 — 3 rules
– 3 rules, Commented Mar 10, 2017 at 6:12

Vijunav Vastivch · Accepted Answer · 2017-03-10 06:10:56Z

3

Do it like this in Query:

declare @sam varchar(50);
set @sam= 'this/is/sample';

select replace(@sam,'/','');

answered Mar 10, 2017 at 6:10

Vijunav Vastivch

4,2111 gold badge18 silver badges32 bronze badges

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

Comments

Tim Biegeleisen · Accepted Answer · 2017-03-10 06:12:10Z

3

Just select the columns you need from the view, but use REPLACE() on the Size column to remove the forward slash:

SELECT [SizePropId],
       [VendorId],
       [VendorName],
       [ModelId],
       [Model],
       [SizeId],
       REPLACE([Size], '/', ''), AS [Size]
       [ProductCode],
       [CategoryId],
       [LoadIndex_Spec],
       [RunFlate],
       [ListPrice]
FROM yourView

answered Mar 10, 2017 at 6:12

Tim Biegeleisen

526k32 gold badges323 silver badges399 bronze badges

1 Comment

3 rules Over a year ago

Thank you so much for such help

ishan joshi · Accepted Answer · 2017-03-15 10:48:04Z

2

Try to use SQL replace function to replace single character

example:

select Replenter code hereace(ColumnName, '/', '') as NewColumnName,* from  TableName

edited Mar 15, 2017 at 10:48

answered Mar 10, 2017 at 6:23

ishan joshi

2703 silver badges13 bronze badges

Collectives™ on Stack Overflow

Remove slash from data and create new field in select query in sql server

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related