Tables Vs Replace Function - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Tables Vs Replace Function

Author

Topic

IT1
Starting Member

5 Posts

Posted - 2005-11-21 : 11:27:04

Here’s the situation:

I need to ask users questions about another person.
The user may be male or female (obviously).
I would like the questions to be gender specific: Him/Her He/She Himself/Herself etc.
E.g.: Does she have good concentration?

Predicament:

Do I create two tables one with male versions of the questions and one with female versions of the questions or…
Do I write them in male then replace with female specific words if needed.

What would you guys/gals do?

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-11-21 : 11:31:05

i'd go with 2 columns.
oh and welcome to THE TEAM!

Go with the flow & have fun! Else fight the flow

IT1
Starting Member

5 Posts

Posted - 2005-11-21 : 11:56:06

ok.

And cheers.
Glad I found this site.

X002548
Not Just a Number

15586 Posts

Posted - 2005-11-21 : 12:24:36

Just have a gender column, in 1 table.

Male, Female, Shemale....

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-11-21 : 12:28:23

ROTFL!!