|
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!
|
|
|
|
|
Sex toys: Member 15898066 - 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!
|
|
|
|
|
Hidden link to courses: Karthee Kumar - 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 15897957 - 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!
|
|
|
|
|
Dev company: Damien Hansen - 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!
|
|
|
|
|
|
"Hire offshore devs": Anjali Kapoor 2023 - 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!
|
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
Car paint repair: Rosemarie Masse - 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!
|
|
|
|
|
|
|
Russian pr0n: Member 15897499 - 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
