Category Archives: SQL

Using Replace In SQL

I really need to learn more about sql statements. So this is how to replace certain words/symbols in SQL statements.

In this example i select value from the field selected and add it to replace function and then add the symbol that you to replace at first parameter and symbol that you want it to be in second parameter.

SQL: Hide Column Based On Parameter

This is how you can hide columns in table based on parameter. This is from an article of SQL Reporting Services With Dynamic Column Reports from codeproject.com. The specific tutorial can be seen in step 10 of that article. Code example. Modified on your own accord.

SQL: Case In IF Statement

This is how you use case expression in if statement.