Click here to Skip to main content
15,868,016 members
Home / Discussions / Spam and Abuse Watch
   

Spam and Abuse Watch

This board allows members to report the accounts of spammers and others who abuse the forums in order to give other members the chance to vote to close the offending account.

 
GeneralRe: Spam would be articles: 15, all "[KBNNN] – Solutions to Fix Windows Update Error Code 0xNNN", "kylie john" Pin
OriginalGriff18-Jan-23 22:02
mveOriginalGriff18-Jan-23 22:02 
GeneralRe: Spam would be articles: 15, all "[KBNNN] – Solutions to Fix Windows Update Error Code 0xNNN", "kylie john" Pin
Ralf Meier18-Jan-23 22:19
professionalRalf Meier18-Jan-23 22:19 
GeneralRe: Spam would be articles: 15, all "[KBNNN] – Solutions to Fix Windows Update Error Code 0xNNN", "kylie john" Pin
OriginalGriff18-Jan-23 22:34
mveOriginalGriff18-Jan-23 22:34 
GeneralMass spamming (member 15898566 | kylie john) - all gone Pin
Graeme_Grant18-Jan-23 20:01
mvaGraeme_Grant18-Jan-23 20:01 
GeneralRe: Mass spamming (member 15898566 | kylie john) - all gone Pin
OriginalGriff18-Jan-23 23:17
mveOriginalGriff18-Jan-23 23:17 
GeneralSpammer from moderation queue (Member 15898695) Pin
OriginalGriff18-Jan-23 19:50
mveOriginalGriff18-Jan-23 19:50 
GeneralSlotbots Pin
OriginalGriff18-Jan-23 19:48
mveOriginalGriff18-Jan-23 19:48 
GeneralChatGPT Plagiarism in Quick Answers (Member: 15897872 | Marco Garganigo) Pin
Graeme_Grant18-Jan-23 18:42
mvaGraeme_Grant18-Jan-23 18:42 
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.

GeneralSlotbot: Member 15898448 Pin
PIEBALDconsult18-Jan-23 13:39
mvePIEBALDconsult18-Jan-23 13:39 
GeneralMember 15898446 is a spammer Pin
PIEBALDconsult18-Jan-23 13:38
mvePIEBALDconsult18-Jan-23 13:38 
GeneralSpam would be article ("Is Web Design Still Trending In 2023?" , Steph Murphy) Pin
OriginalGriff18-Jan-23 8:13
mveOriginalGriff18-Jan-23 8:13 
Generalreportable version Pin
Nelek18-Jan-23 9:13
protectorNelek18-Jan-23 9:13 
GeneralSlotbot: Member 15898169 Pin
OriginalGriff18-Jan-23 6:18
mveOriginalGriff18-Jan-23 6:18 
GeneralSlotbot: Member 15898096 Pin
OriginalGriff18-Jan-23 5:25
mveOriginalGriff18-Jan-23 5:25 
GeneralSpammer from moderation queue (Member 15898066) Pin
OriginalGriff18-Jan-23 5:24
mveOriginalGriff18-Jan-23 5:24 
GeneralSpammer from moderation queue (Karthee Kumar) Pin
OriginalGriff18-Jan-23 5:24
mveOriginalGriff18-Jan-23 5:24 
GeneralSlotbot: Member 15897957 Pin
OriginalGriff18-Jan-23 3:09
mveOriginalGriff18-Jan-23 3:09 
GeneralSpammer from moderation queue (Damien Hansen) Pin
OriginalGriff18-Jan-23 3:08
mveOriginalGriff18-Jan-23 3:08 
GeneralTwo slotbots Pin
PIEBALDconsult18-Jan-23 1:53
mvePIEBALDconsult18-Jan-23 1:53 
GeneralSpammer from moderation queue (Anjali Kapoor 2023) Pin
OriginalGriff18-Jan-23 0:48
mveOriginalGriff18-Jan-23 0:48 
GeneralSpammer - Glass Bead Pin
CHill6017-Jan-23 23:57
mveCHill6017-Jan-23 23:57 
Generalnew Spam-Article (Oracle Apex Training Course Online - HKR) Pin
Ralf Meier17-Jan-23 23:49
professionalRalf Meier17-Jan-23 23:49 
GeneralSpammer from moderation queue (Member 15897753 | eliot j) Pin
Graeme_Grant17-Jan-23 23:44
mvaGraeme_Grant17-Jan-23 23:44 
Generalreportable version Pin
Nelek18-Jan-23 9:14
protectorNelek18-Jan-23 9:14 
GeneralSpammer from moderation queue (Member 15897740 | Sai Kumar 2023) Pin
Graeme_Grant17-Jan-23 23:44
mvaGraeme_Grant17-Jan-23 23:44 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.