I've never tried to use "Like", or maybe it's the single quotes...anyway...
You could try something like:
=IIF(left(Fields!FFOSV1.Value, 3) = "F20", "bla bla", "")
Hope this helps,
Mike,
Thank you for your response.
I think you are correct about the Debug feature not working on functions. I had read the books online, but seeing the Debug greyed-out and also reading comments on other web sites made me think it was possibly permissions. I guess it was wishful thinking...
Somebody please help!
I have a user defined function in SQL Server 2000 that I need to debug. When I go into Query Analyzer and right click on the function in the Object Browser, the Debug option is there, but it is greyed out.
I have opened the Query Analyzer through both Enterprise...
I have Index Server 3.0 running on a Windows 2000 server with IIS 5.0.
In addition to the default Web Catalog, I have created a catalog - CustomerName and added directories for the files to be indexed.
I have edited a query.idq file and query.htx file that properly return records when I used...
I am trying to do this because I need to set up an ODBC connection to an MS Access database on the file server. If I set up a mapped drive using a drive letter, the SQL server cannot access file server to make the ODBC connection unless I am logged on to the server. To the best of my knowledge...
I need to set up a mapped drive on a Windows 2000 server running SQL Server that points to a Windows 2000 file server. The SQL Server needs to be able to access the other server to retrieve data to run a DTS package unattended so it can't be a drive letter mapping.
I have done this in the past...
FYI - I figured it out - when the DSNs were orignially created, the workbook path was set using a mapped network drive for the path instead of the UNC path.
I hope I have this in the right place...
I am receiving the following error when my asp page tries to access an Excel file being used as a database.
[Microsoft][ODBC Excel Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to...
I have created a VB 6.0 app for running a report that uses the Crystal Report Control (CR v. 8.5). The report accesses a SQL Server 7.0 database. Within the SQL Server database, I have a table which stores the document paths for up to 6 documents/record. When I run the report I need to have...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.