Search results for query: *

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!

I have a new version of this request. There are two possible variations for the format of the value in this field: 1. OUT: NAME [09098] 2. IN: OFFSITE STORAGE [OFFICECODE] Can I strip out 'OUT:' AND 'IN:' and the brackets? So that 1. would be NAME 09098 and 2. WOULD BE OFFSITE STORAGE...

Thank you everybody, got what I needed!

The value in the field is OUT: RECORDS FLAG, . [09098] CODE select substring(YourColumn,2,len(YourColumn)-2) from YourTable is returning UT: RECORDS FLAG, . [09098 It stripped one character from the begining and one character from the end of the string. What I need to return is 09098 (or...

I have data in a field - example below: OUT: RECORDS FLAG, . [09098] I need to scan this field and return the data that falls between the brackets []. Can I do that in a query? Thanks.

I have to do something that I'm stumbling on. I have two tables with matching fields and some matching data. Two of the fields are box and ID. There are many id's for each box in the tables. I have to search on box field in table A, then go look for that box in table B...