Viewing 15 posts - 76 through 90 (of 844 total)
All of your examples also only show (23) as what you want to remove, it you know the string then a replace would be the easiest way to remove that...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
September 22, 2022 at 2:18 pm
So what will you store if you have "Apple (Red) (23) (Granny)"? "Apple (Red) (Granny)"?
What is the purpose to remove the number? Can the number be more than 2 digits?
You...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
September 22, 2022 at 1:50 pm
If MarkP is correct on the format, where you want to remove the last 4 characters, why not use this:
SUBSTRING(@var, 1, LEN(@var) - 4)
Replace the @var with your field value.
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
September 21, 2022 at 3:08 pm
What's it say about us that only two people are willing to admit to making mistakes?
I can think of several mistakes I've made just in the last week.
After month's of...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
July 27, 2022 at 2:11 pm
I'm happy with where I work today. I hope to ride it out until retirement, 8 to 10 years or so. I decided after I lost my job over 6...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
July 13, 2022 at 7:02 pm
That'll be a lot of time in an airport or airplane in one year.
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
June 21, 2022 at 1:28 pm
Saw some similar views las month of the mountains as we flew through Denver to Hawaii(and back). Well the wife saw more of it since she was by the window,...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
May 6, 2022 at 4:51 pm
Only been to one on your List Honolulu, passed through Miami and Chicago, both flying and driving.
Places we still want to see are:
Italy, England, France, Spain, Australia, New Zeeland, the Maldives, Fiji, Bora...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
April 29, 2022 at 3:27 pm
I'm trying to get it to be a team, not a developer. I would prefer it to be the same team that is responsible to do our server moves, it's...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
April 26, 2022 at 2:35 pm
Bay
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
April 21, 2022 at 3:21 pm
I don't need a third space. I prefer the WFH, hope we aren't required to come back in full time. They say we can work from anywhere, but I would...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
April 20, 2022 at 4:57 pm
I didn't have any issues with CHAR columns lately, but we have had to adjust the size on our claim number(was char(8)) and policy number(was char(9)) sizes in...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
February 14, 2022 at 3:06 pm
I didn't have any issues with CHAR columns lately, but we have had to adjust the size on our claim number(was char(8)) and policy number(was char(9)) sizes in the last...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
February 11, 2022 at 8:24 pm
Jeff said
"The answer is simple... because it's not bullet proof and it actually takes less effort to make it bullet proof. I've seen too many times where people have changed...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 25, 2022 at 8:17 pm
... Using end of month dates is actually a WORST PRACTICE! ...
I agree with a lot of what you said Jeff, but I can't agree here. I've worked at...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 24, 2022 at 3:55 pm
Viewing 15 posts - 76 through 90 (of 844 total)