SELECT column1, column2, CASE WHEN (column3 = 0) THEN 'Z' ELSE 'C' END FROM table1 ------------- Mostafa Noor Egypt

Hi I have designed a large system for storing files, any kind of files The best way in my opinion is to store files on the hard disk and keep filenames or paths in the DB. Another note will be useful to you: Don't put all files in one folder direcly. This would result in slow serching on a specific file. Rather, you can specify a max file count for each subfolder, say 2000 files. So, if a subfolder reached the 2000-files limit, create a new subfolder and set it the current one. In DB, you can create a table for [SubFolder] contains the fullpath of each subfolder and the table [File] contains a colunm for filename and a column for a foregin key to the parent subfolder. Mostafa Noor Egypt