Help to write a Function

[Olivia123]

Hello,
I need help to write a SQL Statement/ Function that would read this table below...

glrd_acct*glrd_acct1*glrd_cc*glrd_cc1*glrd_user1*code_desc
6401 * 6405 * 1 * 900* 121.01 * SS
8000 * 8999 * 700 * 755 * 150 * AA
9100 * 9120 * A030 * A030 * 389.DUBU * EE

Basically, I need if Account is between glrd_acct and glrd_acct1 and has a CallCenter between glrd_cc and glrd_cc1.....THEN '"'||trim(Account)||'-code_desc"'

Thank you

 

[rac2]

You may wish to post this question in a forum that is specific to the database you use.

For Access that would be

http://www.tek-tips.com/threadminder.cfm?pid=701.

For Microsoft SQL Server that would be

http://www.tek-tips.com/threadminder.cfm?pid=183

Where does Account come from? Is that a column name in a different table? Is it a parameter value from a form?

It may be that a CASE expression or an IIf() function could do the job.

 

[r937]

it can't be access or sql server -- note the very handsome, ANSI-compatible double pipes

;-)

r937.com | rudy.ca