Old post, but maybe this helps someone out:
To complete until it ends up with 4 non-blank characters:
SELECT RIGHT ('0000'+COLUMNNAME, 4) FROM TABLENAME;
To complete until 10:
SELECT RIGHT ('0000000000'+COLUMNNAME, 10) FROM TABLENAME;
@ShadowWizard Regarding your most recent comment reply: I've recently started posting that on unclear bug reports reported through the Android app's bug reporting form, and the last (first) time I did, the author apologized and edited the question, and it was reopened.
I'm not sure it's the same issue: first of all it's an IP ban for some reason (using the common key/simply browsing the site), and secondly I wouldn't use the same key as MetaSmoke
765: unexpected token at '<html>
<head>
<title>Too Many Requests - Stack Exchange</title>
</head>
<body style="font-family:Arial,Helvetica,sans-serif;">
<div style="margin: 0 auto; width: 960px;">
<h2 >We're sorry...</h2>
<p>There are an unusual number of requests coming from this IP address.</p>
<p>To protect our users, we can't process any more requests from this IP address right now.</p>
<p>We'll restore access as quickly as possible, so try again soon.</p>
The translation of "Take care in asking for clarification, commenting, and answering" on ruSO somehow turned out as "Be condescending in asking for clarification, commenting, and answering".
@Bart An increasingly popular pastime. Here at AQW University someone went through the yearbooks up to 100 years old looking for things to be offended by.
It's unfortunate that the Greatest Hits feature is so well hidden. Or maybe fortunate, as in the case of Interpersonal Greatest Hits
> Lying to the StackOverflow Ask Question funnel because I want my question on StackOverflow where it will be seen by a lot of people instead of Superuser, where it won't. -- Mark Fletcher 📎 at 12:56 PM - 8 Apr 2019
Also true for SoftwareRecs, perhaps to a greater degree. Answered + closed > not answered.
Old post, but maybe this helps someone out:
To complete until it ends up with 4 non-blank characters:
SELECT RIGHT ('0000'+COLUMNNAME, 4) FROM TABLENAME;
To complete until 10:
SELECT RIGHT ('0000000000'+COLUMNNAME, 10) FROM TABLENAME;
Wait please stop down-voting! My reputation depends on it!
