Link to home
Start Free TrialLog in
Avatar of geocoins-software
geocoins-software

asked on

SQL - Select ?

I have a 50 Character field (example: NameData) in my table.

the string looks something like this

Jane Doe * CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC

where C is an example of any random character


i was wondering if it was possible to do a select and pull this field, but only return a portion of the field

I need everything to the left of the * (asterisk) including the asterisk

Jane Doe *


Must be done in SQL - NO DELPHI CODE!

Thanks
Avatar of ThievingSix
ThievingSix
Flag of United States of America image

Just a note: Don't put a non delphi question in the Delphi Programming Zone.
ASKER CERTIFIED SOLUTION
Avatar of TheRealLoki
TheRealLoki
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of geocoins-software
geocoins-software

ASKER

ITS MS SQL Server
then my first sample will work, that's what I tested it on (MS SQL 2005)
thanks, i will give it a try tommorrow morning when i get back in the office
select Left(FieldName, 10) from TableName
THAT WORKED!   THANKS!