I discovered this little trick today. If you’re wanting to count the number of characters present in a given SQL Server varchar variable, or common, use the following convention –assuming a search character contained in the variable @SeekChar –from a variable SELECT LEN(@StringVariableName) – LEN(REPLACE(@StringVariableName,@SeekChar,”)) –from a table field SELECT … Continue reading
Monthly Archives: May 2011
Mis-Sold Loan Insurance Spam Text Message – Do Not Reply
DO NOT REPLY EITHER WAY – THIS IS A SCAM Free Message: Important! Our records indicate you may be entitled to £3450 from Mis-Sold Loan Insurance! To claim reply YES to this message. Thank you! Received from: +447848390971/07848390971 This message surfaced on the same day as the decision by the British … Continue reading