Search results
15 kwi 2014 · select REVERSE(substring(REVERSE(@temp),0,CHARINDEX('-',REVERSE(@temp),0))) Give this a shot. It answers your first question of extracting from after the last - of the string. The next part of your question seems to indicate that you want to split the entire thing up based on the -.
23 wrz 2021 · To select words with certain values at the end of the word In SQL, we can use pattern matching. A pattern matching allows users to search for certain patterns in the data. It is done using the LIKE operator in SQL.
28 lip 2021 · Find texts starting, ending or containing a given string. How to select rows where a text column starts by, ends by, or contains a string. Including slightly less trivial cases.
2 mar 2017 · Here is my SQL function: ALTER FUNCTION [dbo].[DescFormatter_New] ( @InputString nvarchar(max), . @MaxLength int=0, @CharPerLine int=0, @NoOfLines int=0. ) RETURNS nvarchar(max) AS. BEGIN . DECLARE @ResultText nvarchar(max) DECLARE @I INT. DECLARE @COUNT INT. IF(LEN(@InputString)<@CharPerLine) BEGIN. SET @ResultText=@InputString. END. ELSE.
1 mar 2021 · The SUBSTRING() function extracts the substring from the specified string based on the specified location. Syntax for SUBSTRING() function: SUBSTRING(expression, starting_position, length) Expression: In this argument, we specify a character, binary, text, ntext, or image expression
22 mar 2022 · SUBSTRING () is a text function that allows you to extract characters from a string. Its syntax is. SUBSTRING (expression, start, length) For the expression argument, you write a string literal or specify a column from which you want to extract the substring.
I found the answer here: http://blog.sqlauthority.com/2007/08/22/sql-server-t-sql-script-to-insert-carriage-return-and-new-line-feed-in-code/ You just concatenate the string and insert a CHAR(13) where you want your line break.
