May 29, 2014 · I asked a previous question with an input->output but the answers weren't in the format I was asking for (the CASE..WHEN inside a substring). Here's a more generalized form …

Mar 9, 2012 · To get the fields (FieldB, FieldC), I need the correct values of paramA = '123' and paramB = '456' so it will return XYZ and John. If I want to return James then i have to give …

Feb 21, 2015 · 3 The character position is wrong. You should start your substring on the position 2 (the first character of your string is 1 and not 0). On the other side, you are using the …

Jan 11, 2011 · I want to write a sql statement to trim a string 'Hello' from the string "Hello World'. Please suggest.

I've started using SUBSTR and INSTR in Oracle but I got confused when I came across this. SELECT PHONE, SUBSTR(PHONE, 1, INSTR(PHONE, '-') -1) FROM DIRECTORY; So I …

In Oracle you can create functions (standalone or in a package) and use them in a select statement.

7 You can concatenate strings to form your LIKE string. To trim the first 3 and last 3 characters from a string use the SUBSTRING and LEN functions. The following example assumes your …

Feb 18, 2015 · 4 You seem to be confusing the concat function, substr function and the concatentation operator (||). You aren't using substr to get the first character of the first name, …

Sep 17, 2014 · In SQL Server, use a combination of PATINDEX, CHARINDEX and SUBSTRING to parse the address from the string in each row. The cursor lets you loop through your table.

Jun 13, 2012 · 81 If you want to get this out of your table using SQL, take a look at the following functions that will help you: SUBSTRING and CHARINDEX. You can use those to trim your …