HELP WITH STATEMENT??

[aaron]

I have a problem, which I do not know if it can be done:

I have a SQL statement, which has:
(USER.first_name = UND.processor)

OK, the problem is that the fieled 'processor' looks like:
lastname, firstname I need to break out the just firstname
in my sql statement.

Please help????

Thanks!!

[Ray at]

What kind of database?
Why are you storing multiple pieces of data in one column?

Ray at work

"aaron" <abroadway@ameritrust.com> wrote in message
news:00c601c38129$76bdd360$a401280a@phx.gbl...

> I have a problem, which I do not know if it can be done:
>
> I have a SQL statement, which has:
> (USER.first_name = UND.processor)
>
> OK, the problem is that the fieled 'processor' looks like:
> lastname, firstname I need to break out the just firstname
> in my sql statement.
>
> Please help????
>
> Thanks!!

[Chris Hohmann]

"aaron" <abroadway@ameritrust.com> wrote in message
news:00c601c38129$76bdd360$a401280a@phx.gbl...

> I have a problem, which I do not know if it can be done:
>
> I have a SQL statement, which has:
> (USER.first_name = UND.processor)
>
> OK, the problem is that the fieled 'processor' looks like:
> lastname, firstname I need to break out the just firstname
> in my sql statement.
>
> Please help????
>
> Thanks!!

Database? Version? Table Structure?

[Ray at]

I don't know anything about Foxpro, so I don't know if these functions
exist, but here is how I would do it in SQL Server (until someone told me
what I was doing wrong and I changed it).


SELECT USER.Whatever,UND.Whatever FROM
USER INNER JOIN UND ON
USER.first_name=RIGHT(UND.processor, LEN(UND.processor) -
CHARINDEX(',', UND.processor) - 1)

I think that's what I mean.

Ray at work




select table1.*, table3.* from
table1 inner join table3 on
table1.Thename = right(table3.Thename, len(table3.thename)- charindex(',',
table3.Thename)-1)

"aaron" <abroadway@ameritrust.com> wrote in message
news:0e7a01c38131$a32d4720$a001280a@phx.gbl...

> Hello, thanks for the reply!
>
> I am using FOXPRO, and I was not the one who designed the
> information flow. I know it is bad design, but I have to
> use it anyway. I am just pulling data out?
>
> THanks,

> >-----Original Message-----
> >What kind of database?
> >Why are you storing multiple pieces of data in one column?
> >
> >Ray at work
> >
> >"aaron" <abroadway@ameritrust.com> wrote in message
> >news:00c601c38129$76bdd360$a401280a@phx.gbl...

> >> I have a problem, which I do not know if it can be done:
> >>
> >> I have a SQL statement, which has:
> >> (USER.first_name = UND.processor)
> >>
> >> OK, the problem is that the fieled 'processor' looks

> like:

> >> lastname, firstname I need to break out the just

> firstname

> >> in my sql statement.
> >>
> >> Please help????
> >>
> >> Thanks!!

> >
> >
> >.
> >