Can you create a rule on more than one column? I want to create a rule for
the following condition, fldname1 != '' OR fldname2 != ''. Is it possible? if
so how?
Your help will be greatly appreciated.
THanks!

You may want to use CHECK constraints for this along the lines of :

CHECK ( col_1 <> '' OR col_2 <> '' )

See SQL Server Books Online for exact syntax, examples & usage details of
check constraints.

HP (H*@discussions.microsoft.com) writes:
To add to Anith's response, note that rules defined by CREATE RULE
are deprecated my Microsoft. I disagree a bit there - I think they are
excellent for user-defined types. But there is never any reason to
bind a rule directly to a column.

Instead you should use constraints, as Anith outlined.

any performance diff using -Between- or >= and <= ?
Spreadsheet totals
Foreign Key may cause multilple cycles
Bulk Insert from Excel
Sort Numbers in Nvarchar As Numbers