This would allow supporting stringr functions like str_detect () and str_replace () which are currently not supported by dbplyr for SQL Server. But, then this would require the user to be on SQL ...

REGEXP(string1, string2)--Returns TRUE if any (possibly empty) substring of string1 matches the Java regular expression string2, otherwise FALSE. Returns NULL if any of arguments is NULL.

To compare two strings you can also use ==. But that might not work as you wanted with strings containing digits because 1 equals 1.00 (but not in a string sense).

I have a column of data with values resembling this: HL7_Result_for_Message_ID_123Q324343.hl7 I need to grab that ID number (in bold), the challenge being that it can be any and all lengths. I have ...

The new features of the most popular open-source database include improved sort and compression, the MERGE command, and other workload management tools. A new version of the popular open-source ...

Is it possible to order by a substring in a returned field?<BR>I've got a query which returns at most probably around 10 or so rows of 1 column. However the way this data is formated, it'd be convient ...