SQL Convert from Percentage to Decimal

I have a table which has a varchar field where the data is stored as a percentage, i.e. 2%. I need to convert this to a decimal but I cannot figure out a convert or cast which will do this? Suggestions?

SQL

Last Comment

Ouida

8/22/2022 - Mon

SOLUTION

Nitin Sontakke

12/29/2017

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

ASKER CERTIFIED SOLUTION

Dustin Saunders

12/29/2017

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

Ouida

12/30/2017

ASKER

Thank you both for your help. It worked with the added /100!

This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.

Certified Expert Program

Credly Partnership

Udemy Partnership