1 Replies - 2891 Views - Last Post: 17 July 2010 - 12:37 AM

#1 Guest_Chad*


Reputation:

Convert Access Sql (JET SQL) statment to T-SQL

Posted 16 July 2010 - 09:20 AM

I'm trying to conver this line out of an access database select statement into a sql T-SQL statement.

Right(nz([Old Description]),Len(nz([Old Description]))+InStr(nz([Old Description])," ")) AS Description

Any Ideas?

Thanks,
Is This A Good Question/Topic? 0

Replies To: Convert Access Sql (JET SQL) statment to T-SQL

#2 Ionut  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 386
  • View blog
  • Posts: 1,057
  • Joined: 17-July 10

Re: Convert Access Sql (JET SQL) statment to T-SQL

Posted 17 July 2010 - 12:37 AM

Hi,

Try this
Right(IsNull(Old Description, ''), Length(IsNull(Old Description, ''))+CHARINDEX(' ', IsNull(Old Description, ''))) AS Description



Ionut

This post has been edited by Ionut: 17 July 2010 - 12:39 AM

Was This Post Helpful? 0
  • +
  • -

Page 1 of 1