|
Member 15898880 - Professional Profile[^]
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
|
|
Craptocurrancy: Social Whispers - Professional Profile[^]
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Member 15898783 - Professional Profile[^]
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
SEO: Member 15898824 - Professional Profile[^]
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Car rental: Paredes Urkao - Professional Profile[^]
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
|
too slow... 😋
Graeme
"I fear not the man who has practiced ten thousand kicks one time, but I fear the man that has practiced one kick ten thousand times!" - Bruce Lee
|
|
|
|
|
It took a long time to type! 
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
All bar the last article I was first to report as spam, so I figured that I was posting. Do you want me to delete my post?
Graeme
"I fear not the man who has practiced ten thousand kicks one time, but I fear the man that has practiced one kick ten thousand times!" - Bruce Lee
|
|
|
|
|
Nah, leave 'em both. 
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Good Morning Griff,
for your info : some of the "Articles" in your List are not marked as Spam yet (or until now only by me).
Chears Ralf
|
|
|
|
|
All gone now - I think you met the second batch by the same idiot!
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
|
He's gone, so I nuked the 60 odd that were left - I edited your post to reflect that so other members don't spend all day trying them! 
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Pr0n stories: Member 15898695 - Professional Profile[^]
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
|
Solution: Remove first char in field mssql[^]
Solution Posted:
To remove the first empty character in a string in SQL, you can use the SUBSTRING() function and the LEN() function. The SUBSTRING() function is used to extract a portion of a string and the LEN() function is used to get the length of a string.
Here is an example of how you can remove the first character from a string stored in the column work_name in a table named dbo.work:
UPDATE dbo.work
SET work_name = SUBSTRING(work_name, 2, LEN(work_name))
My ChatGPT Query Response: chat gpt.png - Google Drive[^]
To remove the first character of a field in a SQL Server table, you can use the SUBSTRING function. Here is an example of how you can update the "work_name" field to remove the first character:
update dbo.work
set work_name = SUBSTRING(work_name, 2, LEN(work_name))
Not 100% identical but it depends on the difference in the questions asked. I just posted the OP's question and text verbatim. The sample code is the same.
Other solutions have the same smell: Member questions & answers[^]
member: Marco Garganigo - Professional Profile[^] - Member since Wed 18 Jan 2023
Graeme
"I fear not the man who has practiced ten thousand kicks one time, but I fear the man that has practiced one kick ten thousand times!" - Bruce Lee
modified 19-Jan-23 0:48am.
|
|
|
|
|
|
|
|
v1 - CodeProject[^]
M.D.V. 
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
Member 15898169 - Professional Profile[^]
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Member 15898096 - Professional Profile[^]
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
