Recent content by FranS37

What did work was a Replace function in BI - replace commas with Char(13): Replace ([fieldname];",";Char(13))

I've only viewed it in SSMS. I want to use the data in an SAP Business Objects report. Thanks.

Thank you for the response. Your suggestions is one I found just doing an on line search, but got the below results: CSR
 REQUEST
 CHECKLIST
 $ using CONVERT(VARCHAR(255),REPLACE((SELECT CONVERT(VARCHAR(30),ApprovalType) + CHAR(13) + CHAR(10) AS 'data()'

The below SQL strings together data from multiple rows, separated by a comma. I need to separate those values with carriage return. I can't make it work with suggestions I'm finding on the web. Any ideas? SELECT DISTINCT p1.RequestLink...

So much harsh judgment :) As a response to a question about a function?

Yep. Invalid length parameter passed to the LEFT or SUBSTRING function. Bye.

Thank you, OlafDoschke. SELECT SUBSTRING(myfield,1,CHARINDEX('-',myfield)) FROM mytable This works, with one minor thing. It includes the '-'. Can't seem to remove it.

Yes, I've tried INSTRING, CHARINDEX, SUBSTRING. I'm looking for examples. Thanks.

I have data that has data before and after a dash. The length of the data is variable. For example: AA11111-000 AA1111-000 I want to return the data to the left of the dash only. Thanks for any help.

I have concatenated words in a cell - a label and then data from another cell. Can I put ascii characters around my label - which would leave the concatenated data unbolded. Without writing vba functions? Any way to just contacte the ascii characters?

Can I join on two fields (from two different tables), and find matches, where the value in one field is, for instance 10015, and the other is 10,015. Is there a way to construct an INNER JOIN to handle that? Thanks.

Ah, if it were true.

Okay, once more? I tried this, but couldn't get it to work. They don't want to see what's between the brackets, so that 2. IN: OFFSITE STORAGE [OFFICECODE] would just return OFFSITE STORAGE Thanks.

Wow, perfect. And I can see what your're doing! Thank you!

Well, not exactly. For example, my 1. would return NAME 09098 Your SQL returns: 09098 Thanks!