Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

how to remove certain rows from query from columns that has data to the right of the column

Avatar of razza_b
razza_b asked on
Microsoft SQL Server
16 Comments1 Solution88 ViewsLast Modified:
Hi

I have a simple query that does this (see attached for output of query)...

                                         SELECT JobdJobKey,JobdStationIDKey,JobdInstruction,JobdRecIdKey
                                         FROM TblJobDetail
                                         WHERE JobdJobKey = 'PNOE143303'  AND JobdStationIDKey='SMT2'
                                                AND JobDInstruction IS NOT NULL
                                                AND JobDInstruction <> ''

and what i need  is to remove the data that is over to the right of the column and just keep all the data on the left of that column.

Hope that makes sense.

Thanks
query-output-from-snippet.docx