I'm guessing a bit here but is this something like what you're after?

create table #mytable

(

Locationvarchar(20)

,shipqtyint

,late_qtyint

,po_datevarchar(10)

)

insert into #mytable (Location,shipqty,late_qty,po_date)

select 'Home',2,3,'02/24/2012' union all

select 'Town',2,5,'01/20/2012' union all

select 'City',5,5,'01/20/2012' union all

select 'Home',4,5,'01/20/2012' union all

select...

How is the date formatted as varchar? Is it in words or 'yyyy-mm-dd', 'dd-mm-yyyy' or 'mm-dd-yyyy' or some variation of that? If you could post some sample data...

We've still got a lot of guesswork to do to help out, and that's what we're here to do. If you read this article and post some samples like...

Could you post some sample data and your expected results please? It will make it a lot easier to answer your questions.

gpascanu (4/11/2014)

---

Hi,

I have the following values in a Float column

266.5

280.98

127.558

How do I set the precision in a SELECT? I need to display two digits after the decimal point. My problem...

Charm

Stuart beat me to it!

Club

BWFC (4/10/2014)

---

With the Numeric data type, the first digit in the bracket gives the maximum number of digits for the complete figure and the second is the maximum number of...

With the Numeric data type, the first digit in the bracket gives the maximum number of digits for the complete figure and the second is the maximum number of digits...

Ice-pop

milos.radivojevic (4/8/2014)

---

Thank you BWFC for the correction!

A great thing in this forum is whenever...

That solution works but will give an error if the string consists of only numerals.

declare @rowstring as varchar(max) = '1251596483'

select

case

when isnumeric(@rowstring) = 1 then @rowstring

else

REVERSE(

SUBSTRING(REVERSE(@rowstring),PATINDEX('%[0-9]%',

REVERSE(@rowstring)),PATINDEX('%[^0-9]%',

SUBSTRING(REVERSE(@rowstring),(PATINDEX('%[0-9]%', REVERSE(@rowstring))),LEN(@rowstring)))-1))

end

That will...

Bells

Shilling

Patriarch

Day