View
-
I need to do a view to export data from SQL Server to FileMaker. So far everything is ok, but now I need to convert a value of a string to another. I also need to do some Select case, If statement in the view to be compatible with FileMaker. Is there a way to do that in a View ? sebastien.lachance.blogspot.com
-
I need to do a view to export data from SQL Server to FileMaker. So far everything is ok, but now I need to convert a value of a string to another. I also need to do some Select case, If statement in the view to be compatible with FileMaker. Is there a way to do that in a View ? sebastien.lachance.blogspot.com
Hi Sebastien. Well, I'm gleaning from your question that you may be interested in the SQL Server
CASEfunction, which you can put in theSELECTstatement for the view. Look it up in the SQL Server books online (specifically the T/SQL documentation) and see if that's what you're looking for. Here's an article about using the CASE statement: http://www.4guysfromrolla.com/webtech/102704-1.shtml[^]